/*Author: Ilana M Ventura														  */
/*Date: September 2024															  */
/*Step 2: Add in Other Specified Coding of Race 								  */
/*		  Correct Initial Race-group flags										  */
/*		  Create multiracial flag												  */




/*************Pull in data from O/S coding*************/
/*Includes original race flags and recode "_add" flags*/
/*O/S variable without back-coding are omitted        */

*SOR, Combined treatment;
data f2a_8_t;
	length f2a_8_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2a_8_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
American,0,0,0,0,0,0,0,1,,,,,,,,,,
American Puerto Rican Arawak Taino Indian,0,1,0,0,0,0,0,1,,,,1,,,,,,
Armenian,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Armenian and Indian,0,0,0,0,0,0,0,1,,,,,1,,,,,
Ashkenazi,0,0,0,0,0,0,0,1,,,,,,,,,,
Ashkenazi,0,0,0,0,1,0,0,1,,,,,,,,,,
Basque,0,1,0,1,1,0,0,1,,,,,,,,,,1
Brazilian,0,0,0,0,0,0,0,1,,,,,,,,,,
Cantaloupe,0,0,0,0,0,0,0,1,,,,,,,,,,
Caribbean,0,0,1,1,0,1,0,1,1,,,,,,,,,1
Caribbean,1,0,0,0,0,0,0,1,,,,,,,,,,1
Caribbean,1,0,0,1,1,0,0,1,,,,,,,,,,1
Caucasian,0,0,0,0,0,0,0,1,,,,,1,,,,,1
"Caucasian, German French",0,0,0,0,0,0,0,1,,,,,1,,,,,1
Cherokee Indian,1,0,0,0,1,0,0,1,,,,1,,,,,,1
Creole,0,0,0,0,0,0,0,1,,,,,,,,,,
Eastern European,0,1,0,0,1,1,0,1,,,,,,,,,,1
Filipino,0,0,0,0,0,1,0,1,,,,,,,,,,1
Foundational Black American,1,0,0,0,0,0,0,1,,,,,,,,,,
Greek,0,0,0,0,1,0,0,1,,,,,,,,,,1
Greek and Polish,0,0,0,0,1,0,0,1,,,,,,,,,,1
"Greek, Spanish, Egyptian",0,0,0,0,0,0,0,1,,1,1,,1,,,,,1
HUMAN,0,0,0,0,0,0,0,1,,,,,,,,,,
Hebrew,0,0,0,0,0,0,0,1,,,,,,,,,,
Hindu,0,0,0,0,0,0,0,1,,,,,,,,,,
Homo sapien,0,0,0,0,0,0,0,1,,,,,,,,,,
Homo sapiens,0,0,0,0,0,0,0,1,,,,,,,,,,
Hong Konger,0,0,0,0,0,0,0,1,,,,,,1,,,,1
Human,0,0,0,0,0,0,0,1,,,,,,,,,,
"Human, there's only one race, lots of ethnicity, based on geography",0,0,0,0,0,0,0,1,,,,,,,,,,
I am no longer willing to be identified by race,0,0,0,0,0,0,0,1,,,,,,,,,,
Indigenous,0,0,0,0,0,0,0,1,,,,1,,,,,,1
Indigenous South American,1,1,0,0,1,0,0,1,,,,1,,,,,,1
Italian American,0,0,0,0,0,0,0,1,,,,,1,,,,,1
"Italian, Jewish and Lithuanian",0,0,1,0,1,0,0,1,,,,,,,,,,
Jewish,0,0,0,0,0,0,0,1,,,,,,,,,,
Jewish,0,0,1,0,0,0,0,1,,,,,,,,,,
Jewish (European/Ashkenazi),0,0,0,0,0,0,0,1,,,,,,,,,,
Jewish American,0,0,0,0,0,0,0,1,,,,,,,,,,
Latin,0,0,0,0,0,0,0,1,,1,,,,,,,,1
Meat Popsicle,0,0,0,0,0,0,0,1,,,,,,,,,,
Mediterranean,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Mixed,0,0,0,0,0,0,0,1,,,,,,,,,,
Mixed American,0,0,0,0,0,0,0,1,,,,,,,,,,
"Mixed Racial Background: French, Cura�ao, West Indian plus a touch of Jewish, Dutch, and East African Ancestry",0,0,0,0,0,0,0,1,1,,,,1,,,,,
Mixed race,0,0,0,0,0,0,0,1,,,,,,,,,,
Mixed race Filipino Irish,0,0,0,0,1,1,0,1,,,,,,,,,,1
Multiethnic Human,1,1,0,1,1,0,0,1,,,,,,,,,,
Multiracial,0,0,0,0,0,0,0,1,,,,,,,,,,
Native/White,0,0,0,0,0,0,0,1,,,,1,1,,,,,1
None,0,0,0,0,0,0,0,1,,,,,,,,,,
None,0,0,0,1,0,1,0,1,,,,,,,,,,
Peruvian Indigenous,0,1,0,0,1,0,0,1,,,,1,,,,,,1
Portuguese,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Portuguese,0,0,0,0,1,0,0,1,,,,,,,,,,1
Portuguese,0,1,0,0,0,0,0,1,,,,,1,,,,,1
Slavic,0,0,0,0,0,0,0,1,,,,,1,,,,,1
"Son of Adam, Human, made in God�s image_",0,0,0,0,0,0,0,1,,,,,,,,,,
"Spaniards ARE white, dumbass ",0,1,0,0,1,0,0,1,,,,,,,,,,1
This is offensive!,0,0,0,0,0,0,0,1,,,,,,,,,,
Turkish,0,0,1,0,0,0,0,1,,,,,1,,,,,1
"Turkish, this depends on how far back you want on my family tree or dna results (which differ a good deal...)",0,0,0,1,1,0,0,1,,,,,,,,,,1
United States American,0,0,0,0,0,0,0,1,,,,,,,,,,
White American,0,0,0,0,1,0,0,1,,,,,,,,,,1
White and Spanish origin,0,1,0,0,0,0,0,1,,,,,1,,,,,1
Yaqui and Seri Mexican indigenous,0,1,0,0,0,0,0,1,,,,1,,,,,,1
american made,0,0,0,1,0,0,0,1,,,,,,,,,,
human,0,0,0,0,0,0,0,1,,,,,,,,,,
human,0,1,1,1,1,0,0,1,,,,,,,,,,
human race,0,0,0,0,0,0,0,1,,,,,,,,,,
mix,0,0,0,0,0,0,0,1,,,,,,,,,,
mixed,0,0,0,0,0,0,0,1,,,,,,,,,,
mixed,0,0,0,0,1,1,0,0,,,,,,,,,,
othr,0,0,0,0,0,0,0,1,,,,,,,,,,
portuguese,0,0,0,0,0,0,0,1,,,,,1,,,,,1
racist question,0,0,0,0,0,0,0,1,,,,,,,,,,
;
run;

*White, Combined treatment;
data f2a_1_t;
	length f2a_1_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2a_1_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
", Slavic, Scandinavian",1,1,0,0,1,0,0,0,,,,,,,,,,
"1/2 CROATIAN, OTHER HALF VERY MIXED, SOME GERMAN",0,0,0,0,1,0,0,0,,,,,,,,,,
Albanian,0,0,0,0,1,0,0,0,,,,,,,,,,
American,0,0,0,0,1,0,0,0,,,,,,,,,,
American,0,0,0,0,1,0,0,1,,,,,,,,,,
American,0,0,0,0,1,1,0,0,,,,,,,,,,
American,0,1,0,0,1,0,0,0,,,,,,,,,,
Armenian,0,0,0,0,1,0,0,0,,,,,,,,,,
"Armenian, Spanish, Portuguese",0,0,0,0,1,0,0,0,,,,,,,,,,
Asian,0,0,0,0,1,0,0,0,,,,,,,,,,
Askinizi jew,0,0,0,0,1,0,0,0,,,,,,,,,,
Austrian,0,1,0,0,1,0,0,0,,,,,,,,,,
"Austrian, Hungarian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Austrian, Spanish",0,1,0,0,1,0,0,0,,,,,,,,,,
"Basque, Russian, Ukrainian",0,1,1,0,1,0,0,0,,,,,,,,,,
"Basque, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
Belarusian,0,0,0,0,1,0,0,0,,,,,,,,,,
Belarusian,0,1,0,1,1,0,0,0,,,,,,,,,,
Belgian,0,0,0,0,1,0,0,0,,,,,,,,,,
Belgium,0,1,0,0,1,0,0,0,,,,,,,,,,
Bohemian,0,0,0,0,1,0,0,0,,,,,,,,,,
Bohemian,0,1,0,0,1,0,0,0,,,,,,,,,,
Bohemian and Portuguese,0,0,0,0,1,0,0,1,,,,,,,,,,
British,0,0,0,0,1,0,0,0,,,,,,,,,,
Canadian,0,0,0,0,1,0,0,0,,,,,,,,,,
Caucasian,0,0,0,0,1,0,0,0,,,,,,,,,,
Caucasian,1,0,0,0,1,0,0,1,,,,,,,,,,
Croatian,0,0,0,0,1,0,0,0,,,,,,,,,,
Cuban,0,1,0,0,1,0,0,0,,,,,,,,,,
Czech,0,0,0,0,1,0,0,0,,,,,,,,,,
Czech,0,0,0,0,1,1,0,0,,,,,,,,,,
Czech,0,1,0,0,1,1,0,0,,,,,,,,,,
"Czech,Austria",0,0,0,0,1,0,0,0,,,,,,,,,,
"Czechoslavakian, Welsh, Mexican",0,0,0,0,1,0,0,0,,1,,,,,,,,
Czechoslovakia,0,1,0,0,1,0,0,0,,,,,,,,,,
Czechoslovakian,0,1,0,0,1,0,0,0,,,,,,,,,,
Danish,0,0,0,0,1,0,0,0,,,,,,,,,,
Danish,0,0,0,0,1,1,0,0,,,,,,,,,,
Danish,1,0,0,1,1,0,0,1,,,,,,,,,,
"Danish, Czech",0,0,0,0,1,0,0,0,,,,,,,,,,
Denmark,0,0,0,0,1,0,0,0,,,,,,,,,,
Don't know,0,0,0,0,1,1,0,0,,,,,,,,,,
Dont know,0,1,0,0,1,0,0,0,,,,,,,,,,
Don�t know,0,0,0,0,1,0,0,0,,,,,,,,,,
Dutch,0,0,0,0,1,0,0,0,,,,,,,,,,
Dutch,0,0,0,0,1,1,0,0,,,,,,,,,,
Dutch,0,0,0,1,1,0,0,0,,,,,,,,,,
Dutch,0,1,0,0,1,1,0,0,,,,,,,,,,
Dutch,0,1,0,1,1,0,0,0,,,,,,,,,,
Dutch,0,1,1,0,1,0,0,0,,,,,,,,,,
Dutch,1,0,0,1,1,0,0,0,,,,,,,,,,
Dutch and German,0,0,0,0,1,0,0,0,,,,,,,,,,
"Dutch, Finnish",0,0,0,0,1,1,0,0,,,,,,,,,,
"Dutch, Russian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Dutch, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Dutch, Scottish,",0,0,0,0,1,0,0,0,,,,,,,,,,
Eastern European,0,0,0,0,1,0,0,0,,,,,,,,,,
"England & Northwestern Europe, Scotland, Eastern Europe & Russia, Germanic Europe, The Balkans, Jewish, Wales, Ireland, Norway, Baltics",0,0,0,0,1,0,0,0,,,,,,,,,,
English,0,0,0,0,1,0,0,0,,,,,,,,,,
European Spanaird,0,1,0,0,1,0,0,0,,,,,,,,,,
Finnish,0,1,0,0,1,0,0,0,,,,,,,,,,
"For heaven' sake, WHERE you are born does not constitute your RACE! I was born in Cuba and my herutage is from Spain BUT my race is Caucasian. That IS possible!!",0,1,0,0,1,0,0,0,,,,,,,,,,
Greek,0,0,0,0,1,0,0,0,,,,,,,,,,
Greek,0,0,0,0,1,0,0,1,,,,,,,,,,
Greek,0,1,0,0,1,0,0,0,,,,,,,,,,
Greek,1,1,0,1,1,0,0,0,,,,,,,,,,
Hispanic,0,0,0,0,1,0,0,0,,1,,,,,,,,
Hispanic,0,1,0,0,1,0,0,0,,,,,,,,,,
Hungarian,0,0,0,0,1,0,0,0,,,,,,,,,,
Hungarian,0,1,0,0,1,0,0,0,,,,,,,,,,
Hungarian German,0,0,0,1,1,0,0,0,,,,,,,,,,
I don't know,0,0,0,0,1,0,0,0,,,,,,,,,,
I have multiple nationalities in my bloodline,0,0,0,0,1,0,0,0,,,,,,,,,,
I'm white,0,0,0,0,1,0,0,0,,,,,,,,,,
Indian dutch,0,0,0,0,1,0,0,0,,,,,,,,,,
Italian,0,1,0,0,1,0,0,0,,,,,,,,,,
Jew,0,0,0,0,1,0,0,0,,,,,,,,,,
Jewish,0,0,0,0,1,0,0,0,,,,,,,,,,
Jewish,0,1,0,0,1,0,0,0,,,,,,,,,,
Jewish Hungarian,0,0,0,0,1,0,0,0,,,,,,,,,,
Latvian and Romanian,0,0,0,0,1,0,0,0,,,,,,,,,,
Lithuanian,0,0,1,0,1,0,0,1,,,,,,,,,,
Lithuanian,0,1,0,0,1,0,0,0,,,,,,,,,,
Lithuianian,0,0,0,0,1,0,0,0,,,,,,,,,,
Luxembourg,0,0,0,0,1,0,0,0,,,,,,,,,,
Luxembourgish,0,0,0,0,1,0,0,0,,,,,,,,,,
Magyar,0,0,0,0,1,1,0,0,,,,,,,,,,
Mexican,0,0,0,0,1,0,0,0,,1,,,,,,,,
Mix native American and Irish and Scottish,0,0,0,0,1,0,0,0,,,,1,,,,,,
Native American,0,0,0,0,1,0,0,0,,,,1,,,,,,
Netherlands,0,0,0,0,1,0,0,0,,,,,,,,,,
"No idea, though born in the PNW of the USA, and just... white",0,0,0,0,1,0,0,0,,,,,,,,,,
None,0,0,0,0,1,1,0,0,,,,,,,,,,
Norwegian,0,0,0,0,1,0,0,0,,,,,,,,,,
Norwegian,0,0,0,0,1,1,0,0,,,,,,,,,,
Norwegian,0,1,0,0,1,0,0,0,,,,,,,,,,
Norwegian,0,1,0,0,1,1,1,0,,,,,,,,,,
Norwegian,0,1,0,1,1,0,0,0,,,,,,,,,,
Norwegian,0,1,0,1,1,0,0,1,,,,,,,,,,
Norwegian Scottish Welsh,0,0,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, Danish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, Danish",0,1,0,0,1,1,0,0,,,,,,,,,,
"Norwegian, Finnish, American Indian, Czechoslovakian",0,0,0,0,1,0,0,0,,,,1,,,,,,
"Norwegian, Slovenian, Austrian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, Swedish, Dutch, Danish, Bulgarian, Greek & Finish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, Swedish, Irish for the most part",0,0,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, dutch",0,0,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
Norweigan,0,0,0,0,1,0,0,0,,,,,,,,,,
Norweigan,0,1,0,0,1,0,0,0,,,,,,,,,,
Not sure,0,0,0,0,1,0,0,0,,,,,,,,,,
Not sure,0,0,0,0,1,1,0,0,,,,,,,,,,
Not sure,0,1,0,0,1,0,0,0,,,,,,,,,,
Persian,0,0,0,0,1,0,0,0,,,1,,,,,,,
Peruvian,0,1,0,0,1,0,0,1,,,,,,,,,,
Portugeese,0,1,0,0,1,0,0,0,,,,,,,,,,
Portuguese,0,0,0,0,1,0,0,0,,,,,,,,,,
Portuguese,0,0,0,0,1,1,1,0,,,,,,,,,,
Portuguese and Dutch,0,0,0,0,1,0,0,0,,,,,,,,,,
Portuguese and Lithuanian,0,1,0,1,1,0,0,0,,,,,,,,,,
"Portuguese, spanish",0,1,0,0,1,0,0,0,,,,,,,,,,
Romanian,0,1,0,1,1,0,0,0,,,,,,,,,,
"Romanian, Macedonian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Russia, Holland",0,0,0,0,1,0,0,0,,,,,,,,,,
Russian,0,0,0,0,1,0,0,0,,,,,,,,,,
Russian,0,0,0,0,1,1,0,0,,,,,,,,,,
Russian,0,0,1,0,1,0,0,0,,,,,,,,,,
Russian,0,1,0,0,1,0,0,0,,,,,,,,,,
"Russian, Norwegian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Russian, Romanian",0,1,0,0,1,0,0,0,,,,,,,,,,
Scandanavian and Ukrainian,1,1,1,0,1,0,0,0,,,,,,,,,,
Scandinavian,0,0,0,0,1,0,0,0,,,,,,,,,,
Scandinavian,0,0,0,0,1,1,0,0,,,,,,,,,,
"Scot, Norwegian, Irish,Italian , Greek,Spanish,Dutch,Turk & Sri Lankan Tamil",0,0,0,0,1,0,0,0,,1,,,,1,,,,
"Scotch, Welsh",1,1,0,1,1,0,0,0,,,,,,,,,,
Scotish,0,1,0,0,1,0,0,0,,,,,,,,,,
"Scotish,welsh",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scots, Dutch, Spanish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scott, Russian",0,0,0,0,1,0,0,0,,,,,,,,,,
Scottish,0,0,0,0,1,0,0,0,,,,,,,,,,
Scottish,0,0,0,0,1,1,0,0,,,,,,,,,,
Scottish,0,0,0,0,1,1,1,0,,,,,,,,,,
Scottish,0,0,0,1,1,0,0,0,,,,,,,,,,
Scottish,0,1,0,0,1,0,0,0,,,,,,,,,,
Scottish,0,1,0,0,1,1,0,0,,,,,,,,,,
Scottish,0,1,0,1,1,0,0,0,,,,,,,,,,
Scottish,1,0,0,1,1,0,0,0,,,,,,,,,,
Scottish,1,1,0,1,1,0,0,0,,,,,,,,,,
Scottish Scandinavian,0,0,1,0,1,0,0,0,,,,,,,,,,
Scottish and English,0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, American (pre revolutionary war white)",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Danish, Norwegian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Dutch",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Dutch",0,0,0,0,1,1,0,0,,,,,,,,,,
"Scottish, Dutch, Welsh",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Eastern European",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Hungarian",0,1,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Native American",0,1,0,0,1,0,0,0,,,,1,,,,,,
"Scottish, Norwegian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Norwegian, Swedish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Norwegian, Welsh",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Scandinavian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Spanish",0,1,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Swedish, Danish",0,1,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Wales, Greek",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Welch",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scottish, Welsh",0,1,0,0,1,0,0,0,,,,,,,,,,
"Scottish, barbadosian, cherokee",0,0,0,0,1,0,0,0,,,,1,,,,,,
Scottish/Welsh/,1,1,0,1,1,0,0,0,,,,,,,,,,
Sicilian,0,1,0,0,1,0,0,0,,,,,,,,,,
Slavic,0,0,0,0,1,0,0,0,,,,,,,,,,
Slovak,0,0,0,0,1,0,0,0,,,,,,,,,,
Slovak,0,1,0,0,1,0,0,0,,,,,,,,,,
"Slovak, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
Slovakia,0,0,0,0,1,0,0,0,,,,,,,,,,
Spain,0,1,0,0,1,0,0,0,,,,,,,,,,
Spaniard,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish,1,1,0,1,1,0,0,1,,,,,,,,,,
"Spanish, Portuguese",0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish/ Portuguese,0,1,0,0,1,1,0,0,,,,,,,,,,
Swedish,0,0,0,0,1,0,0,0,,,,,,,,,,
Swedish,0,0,0,0,1,0,0,1,,,,,,,,,,
Swedish,0,0,0,0,1,1,0,0,,,,,,,,,,
Swedish,0,1,0,0,1,0,0,0,,,,,,,,,,
"Swedish, Czech",0,0,0,0,1,0,0,0,,,,,,,,,,
"Swedish, Danish",0,0,0,0,1,1,0,0,,,,,,,,,,
"Swedish, Danish, Native American",0,0,0,0,1,0,0,0,,,,1,,,,,,
"Swedish, Dutch",0,0,0,0,1,1,1,0,,,,,,,,,,
"Swedish, Finland, Bulgarian, Iberian",0,1,0,0,1,1,0,1,,,,,,,,,,
"Swedish, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
Swiss,0,0,0,0,1,0,0,0,,,,,,,,,,
"Swiss, Austrian, Croatian",0,0,0,0,1,0,0,0,,,,,,,,,,
Ukrainian,0,0,0,0,1,0,0,0,,,,,,,,,,
Ukrainian,0,0,0,0,1,1,0,0,,,,,,,,,,
Unknown,0,0,0,0,1,0,0,0,,,,,,,,,,
Unknown,0,1,0,0,1,0,0,0,,,,,,,,,,
Venezuelan,0,1,0,0,1,0,0,0,,,,,,,,,,
Welch,0,0,0,0,1,0,0,0,,,,,,,,,,
Welsh,0,0,0,0,1,0,0,0,,,,,,,,,,
Welsh,0,1,0,0,1,0,0,0,,,,,,,,,,
"Welsh, Scottish,",0,0,0,1,1,0,0,1,,,,,,,,,,
american,0,0,0,0,1,0,0,0,,,,,,,,,,
ashkenasi,0,0,0,0,1,0,0,0,,,,,,,,,,
danish,0,0,0,0,1,0,0,0,,,,,,,,,,
don't know,0,1,0,0,1,0,0,0,,,,,,,,,,
eastern european,0,0,0,0,1,0,0,0,,,,,,,,,,
indian,0,0,1,1,1,1,0,0,,,,,,,,,,
jewish,0,0,0,0,1,0,0,0,,,,,,,,,,
mixed,0,1,0,0,1,0,0,0,,,,,,,,,,
native american,0,0,0,0,1,0,0,0,,,,1,,,,,,
none,0,1,0,0,1,0,0,0,,,,,,,,,,
norwegian,0,0,0,0,1,0,0,0,,,,,,,,,,
not sure of specific ethnicity,0,0,0,0,1,0,0,0,,,,,,,,,,
russian,0,0,0,0,1,0,0,0,,,,,,,,,,
russian,0,0,0,0,1,1,0,0,,,,,,,,,,
scotch-irish,0,1,0,0,1,0,0,0,,,,,,,,,,
scottish,0,0,0,0,1,0,0,0,,,,,,,,,,
scottish,0,0,0,0,1,1,0,0,,,,,,,,,,
sweden,0,0,0,0,1,0,0,0,,,,,,,,,,
swedish,0,0,0,0,1,0,0,0,,,,,,,,,,
unknown,0,0,0,0,1,0,0,0,,,,,,,,,,
us,0,0,0,0,1,0,0,0,,,,,,,,,,
usa,0,0,0,0,1,0,0,0,,,,,,,,,,
welsh,0,0,0,0,1,0,0,0,,,,,,,,,,
"welsh, danish",0,0,0,0,1,0,0,0,,,,,,,,,,
white,0,0,0,0,1,1,0,0,,,,,,,,,,
run;

*Hispanic, Combined treatment;
data f2a_2_t;
	length f2a_2_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2a_2_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
Argentina,0,1,0,0,0,0,0,0,,,,,,,,,,
Argentina,0,1,0,0,1,0,0,0,,,,,,,,,,
Argentinian,0,1,0,0,0,0,0,0,,,,,,,,,,
Argentinian,0,1,0,0,1,0,0,0,,,,,,,,,,
Belizean,0,1,0,0,0,0,0,0,,,,,,,,,,
Bolivian,0,1,0,0,1,0,0,0,,,,,,,,,,
Brazil,0,1,0,0,0,0,0,0,,,,,,,,,,
Brazilian,0,1,0,0,0,0,0,0,,,,,,,,,,
Brazilian,0,1,0,0,0,1,0,0,,,,,,,,,,
Brazilian,0,1,0,0,1,0,0,0,,,,,,,,,,
"Catalan, Basque, Castilloan",0,1,0,0,1,1,0,0,,,,,,,,,,
Chilean,0,1,0,0,0,0,0,0,,,,,,,,,,
"Chilean, Spaniard",0,1,1,0,1,0,0,0,,,,,,,,,,
Colombian,0,1,0,0,0,0,0,0,,,,,,,,,,
Costa Rican,0,1,0,0,0,0,0,0,,,,,,,,,,
"Costa Rican, Spanish, Nicarag�ense",0,1,0,0,0,0,0,0,,,,,,,,,,
Ecuador,0,1,0,0,0,0,0,0,,,,,,,,,,
Ecuador Costa Rica,0,1,0,0,0,0,0,0,,,,,,,,,,
"Ecuadorean, Uruguayan",0,1,0,0,0,0,0,0,,,,,,,,,,
Ecuadorian,0,1,0,0,0,0,0,0,,,,,,,,,,
Ecuadorian,0,1,0,0,1,0,0,0,,,,,,,,,,
Ecuadorian,1,1,0,0,1,0,0,1,,,,,,,,,,
European Spanaird,0,1,0,0,1,0,0,0,,,,,,,,,,
Guatemalan,0,1,0,0,0,0,0,0,,,,,,,,,,
Guatemalan,0,1,0,0,1,0,0,0,,,,,,,,,,
Guatemalan,0,1,0,1,0,0,0,0,,,,,,,,,,
Guatemalan,0,1,0,1,1,0,0,0,,,,,,,,,,
Guatemalan and Spaniard,0,1,0,0,0,0,0,0,,,,,,,,,,
"Hispano, Tejano and Mexican",0,1,0,0,0,0,0,0,,,,,,,,,,
Honduran,0,1,0,0,0,0,0,0,,,,,,,,,,
Honduran,0,1,0,0,1,0,0,0,,,,,,,,,,
Honduran,1,1,0,0,0,0,0,0,,,,,,,,,,
Honduras,0,1,0,0,0,0,0,0,,,,,,,,,,
Honduras,1,1,0,0,0,0,0,0,,,,,,,,,,
Huastec,0,1,0,1,0,0,0,0,,,,,,,,,,
Iberian,0,1,0,0,1,0,0,0,,,,,,,,,,
Margid,0,1,0,0,1,1,0,0,,,,,,,,,,
"Mexica, Otom�, Chichimeca",0,1,0,1,0,0,0,0,,,,,,,,,,
Mothers side was Spanish / Native American from Mexico. Dads Side was Spanish and Native American Ute,0,1,0,1,0,0,0,0,,,,,,,,,,
Multiple,0,1,0,0,0,0,0,0,,,,,,,,,,
Nicaragua,0,1,0,0,0,0,0,0,,,,,,,,,,
Nicaraguan,0,1,0,0,0,0,0,0,,,,,,,,,,
Nicarag�en,0,1,0,0,0,0,0,0,,,,,,,,,,
Nicarag�ense,0,1,0,0,0,0,0,0,,,,,,,,,,
Panamanian,0,1,0,0,0,0,0,0,,,,,,,,,,
Panamanian,0,1,0,0,1,0,0,0,,,,,,,,,,
Panamanian,1,1,0,0,0,0,0,0,,,,,,,,,,
"Panamanian, Costa Rican",0,1,0,0,1,0,0,0,,,,,,,,,,
Peruvian,0,1,0,0,0,0,0,0,,,,,,,,,,
Peruvian,0,1,0,0,0,1,0,0,,,,,,,,,,
Peruvian,0,1,0,0,1,0,0,0,,,,,,,,,,
Peruvian,0,1,0,0,1,0,0,1,,,,,,,,,,
Peruvian,0,1,0,0,1,1,0,0,,,,,,,,,,
Peruvian,0,1,0,0,1,1,0,1,,,,,,,,,,
"Peruvian, Brasilian",0,1,0,0,0,0,0,0,,,,,,,,,,
Peruvian-Mexican American,0,1,0,0,0,0,0,0,,,,,,,,,,
See my comment under WHITE,0,1,0,0,1,0,0,0,,,,,,,,,,
Spain,0,1,0,0,0,1,0,0,,,,,,,,,,
Spain,0,1,0,0,1,0,0,0,,,,,,,,,,
Spain,1,1,0,0,0,0,0,0,,,,,,,,,,
Spainard,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanaird,0,1,0,1,1,0,0,0,,,,,,,,,,
Spaniard,0,1,0,0,0,0,0,0,,,,,,,,,,
Spaniard,0,1,0,0,0,1,0,0,,,,,,,,,,
Spaniard,0,1,0,0,1,0,0,0,,,,,,,,,,
Spaniard,0,1,0,0,1,1,0,0,,,,,,,,,,
Spaniard,0,1,0,0,1,1,1,0,,,,,,,,,,
Spaniard,0,1,0,1,0,0,0,0,,,,,,,,,,
Spaniard,0,1,0,1,0,1,0,0,,,,,,,,,,
Spaniard,0,1,0,1,1,0,0,0,,,,,,,,,,
Spaniard,0,1,1,0,0,0,0,0,,,,,,,,,,
Spaniard,1,1,0,0,1,0,0,0,,,,,,,,,,
Spaniard,1,1,0,1,1,0,0,0,,,,,,,,,,
"Spaniard, African, Taino",0,1,0,0,0,0,0,0,1,,,1,,,,,,
"Spaniard, Apache",0,1,0,1,0,0,0,0,,,,,,,,,,
"Spaniard, Portuguese",0,1,0,0,1,1,0,0,,,,,,,,,,
Spaniards American,0,1,0,0,0,0,0,0,,,,,,,,,,
Spanish,0,1,0,0,0,0,0,0,,,,,,,,,,
Spanish,0,1,0,0,0,1,0,0,,,,,,,,,,
Spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish,0,1,0,0,1,1,0,0,,,,,,,,,,
Spanish,0,1,0,1,1,0,0,0,,,,,,,,,,
Spanish,1,1,0,1,1,0,0,0,,,,,,,,,,
Spanish,1,1,1,0,1,0,0,0,,,,,,,,,,
Spanish Portuguese,0,1,0,0,0,0,0,1,,,,,,,,,,
Spanish and Portuguese,1,1,0,1,0,0,0,0,,,,,,,,,,
Spanish-Spain,0,1,0,1,1,0,0,0,,,,,,,,,,
Uruguayan and Brazilian,0,1,0,1,1,0,0,0,,,,,,,,1,,
VENEZUELA,0,1,0,0,0,0,0,0,,,,,,,,,,
Venezuela,0,1,0,0,0,0,0,0,,,,,,,,,,
Venezuelan,0,1,0,0,0,0,0,0,,,,,,,,,,
Venezuelan,0,1,0,0,1,0,0,0,,,,,,,,,,
White Spanish,0,1,0,0,0,0,0,1,,,,,,,,,,
bolivian,0,1,0,0,0,0,0,0,,,,,,,,,,
guatemalan,0,1,0,0,0,0,0,0,,,,,,,,,,
honduras,0,1,0,0,0,0,0,0,,,,,,,,,,
nicaragua,0,1,0,0,0,0,0,0,,,,,,,,,,
nicaraguan,0,1,0,0,1,0,0,0,,,,,,,,,,
peruivan,0,1,0,0,1,0,0,0,,,,,,,,,,
peruvian,0,1,0,0,0,0,0,0,,,,,,,,,,
spain,0,1,0,0,0,0,0,0,,,,,,,,,,
"spain, portugal",0,1,1,0,1,0,0,0,,,,,,,,,,
spaniard,0,1,0,0,0,0,0,0,,,,,,,,,,
spaniard,0,1,0,1,1,0,0,0,,,,,,,,,,
spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
spanish,1,1,0,0,1,0,0,0,,,,,,,,,,
uruguayiasn,0,1,0,0,1,0,0,0,,,,,,,,,,
venezuelan,0,1,0,0,0,0,0,0,,,,,,,,,,
run;

*Black, Combined treatment;
data f2a_3_t;
	length f2a_3_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2a_3_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
AMERICAN OF AFRICAN DESCENT,1,0,0,0,0,0,0,0,,,,,,,,,,
African descent South america,1,1,0,0,1,0,0,1,,,,,,,,,,
Afro-Caribbean,1,0,0,1,1,1,0,0,,,,,,,,,,
American,1,0,0,0,0,0,0,0,,,,,,,,,,
Angolan,1,0,0,0,0,0,0,0,,,,,,,,,,
Bahamian,1,0,0,0,0,0,0,0,,,,,,,,,,
Black,1,0,0,0,0,0,0,0,,,,,,,,,,
Cape Verde,1,1,0,0,0,0,0,0,,,,,,,,,,
Cape Verdian,1,0,0,0,0,0,0,0,,,,,,,,,,
Congolese,1,0,0,0,0,0,0,0,,,,,,,,,,
Dominican,1,0,0,0,0,0,0,0,,1,,,,,,,,
Dominican,1,1,0,0,1,0,0,0,,,,,,,,,,
Florida Seminole,1,0,0,1,0,0,0,0,,,,,,,,,,
Foundational Black American,1,0,0,0,0,0,0,1,,,,,,,,,,
Ghana,1,1,0,0,1,0,0,0,,,,,,,,,,
Ghanaian,1,0,0,0,0,0,0,0,,,,,,,,,,
Ghanaian,1,0,0,1,1,1,0,0,,,,,,,,,,
Guyanese,1,0,0,0,0,0,0,0,,,,,,,,,,
Kenyan-American,1,0,0,0,0,0,0,0,,,,,,,,,,
Liberian,1,0,0,0,0,0,0,0,,,,,,,,,,
Liberian,1,0,1,0,0,1,0,0,,,,,,,,,,
"Mali, Angolian, Sierra Leone, and Namibian",1,1,0,1,0,0,0,0,,,,,,,,,,
Moor,1,1,0,1,1,0,0,0,,,,,,,,,,
None,1,0,0,0,1,0,0,0,,,,,,,,,,
Senegal,1,1,0,0,1,0,0,0,,,,,,,,,,
South Africa,1,0,0,0,0,0,0,0,,,,,,,,,,
St.Croix,1,0,0,0,0,0,0,1,,,,,,,,,,
Tanzanian,1,0,0,0,0,0,0,0,,,,,,,,,,
Trinidadian,1,0,0,0,0,0,0,0,,,,,,,,,,
Trinidadian and Tobagonian,1,0,0,0,0,0,0,0,,,,,,,,,,
U.S. Citizen,1,0,0,0,0,0,0,0,,,,,,,,,,
Ugandan,1,0,0,0,0,1,0,0,,,,,,,,,,
Unknown,1,0,0,1,1,0,0,0,,,,,,,,,,
Virgin Island,1,0,0,1,1,0,0,1,,,,,,,,,,
West African,1,1,0,1,1,0,0,1,,,,,,,,,,
Zambian,1,0,0,0,0,0,0,0,,,,,,,,,,
kenyan,1,0,0,0,0,0,0,0,,,,,,,,,,
not sure,1,0,0,1,1,0,0,0,,,,,,,,,,
run;

*White, Seperate treatment;
data f2b_1_t;
	length f2b_1_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2b_1_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
.,0,0,0,0,1,0,0,0,,,,,,,,,,
"Albanian, German, Hungarian, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
American,0,0,0,0,1,0,0,0,,,,,,,,,,
American,0,0,0,1,1,0,0,0,,,,,,,,,,
American,0,1,0,0,1,0,0,0,,,,,,,,,,
American,0,1,0,1,1,0,0,0,,,,,,,,,,
American of Mexican desent,0,1,0,0,1,0,0,0,,,,,,,,,,
American only.,0,0,0,0,1,0,0,0,,,,,,,,,,
American with Hispanic decent,0,1,0,0,1,0,0,0,,,,,,,,,,
Americano,0,1,0,0,1,0,0,0,,,,,,,,,,
Ancestors from the United Kingdom,0,0,0,0,1,0,0,0,,,,,,,,,,
Anglo Saxon,0,0,0,0,1,0,0,0,,,,,,,,,,
Anglo-Franco Celtic Mix,0,0,0,0,1,0,0,0,,,,,,,,,,
Ashkenazi,0,1,0,0,1,0,0,0,,,,,,,,,,
Ashkenazi Jew,0,0,0,0,1,0,0,0,,,,,,,,,,
Ashkenazi Jewish,0,0,0,0,1,0,0,0,,,,,,,,,,
Austrian,0,0,0,0,1,0,0,0,,,,,,,,,,
Belgian,0,0,0,0,1,1,0,0,,,,,,,,,,
Bohemian,0,1,0,0,1,0,0,1,,,,,,,,,,
British,0,0,0,0,1,0,0,0,,,,,,,,,,
British,0,0,0,0,1,1,0,0,,,,,,,,,,
British,1,1,0,0,1,0,0,0,,,,,,,,,,
"British, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
Bulgarian,0,0,0,0,1,0,0,0,,,,,,,,,,
Canadian,0,1,0,0,1,0,0,0,,,,,,,,,,
"Canadian, Belgian",0,0,0,0,1,0,0,0,,,,,,,,,,
Caucasian,0,0,0,0,1,0,0,0,,,,,,,,,,
Caucasian,0,1,0,0,1,0,0,0,,,,,,,,,,
Caucasian mix Mexican American,0,1,0,0,1,0,0,0,,,,,,,,,,
Centro American,0,1,0,0,1,0,0,0,,,,,,,,,,
Chilean,0,1,0,0,1,0,0,0,,,,,,,,,,
Colombian,0,1,0,0,1,0,0,0,,,,,,,,,,
Croatian,0,1,0,0,1,0,0,0,,,,,,,,,,
Cuban,0,1,0,0,1,0,0,0,,,,,,,,,,
Cuban American,0,1,0,0,1,0,0,0,,,,,,,,,,
Cuban-american,0,1,0,0,1,0,0,0,,,,,,,,,,
Czech and Mexican,0,1,0,0,1,0,0,0,,,,,,,,,,
"Czech, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
Danish,0,1,0,0,1,0,0,0,,,,,,,,,,
Danish-English-French~Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
Don't know,0,1,0,0,1,0,0,0,,,,,,,,,,
Dutch,0,0,0,0,1,0,0,0,,,,,,,,,,
Dutch,0,0,0,0,1,1,0,0,,,,,,,,,,
Dutch and English,0,0,0,0,1,0,0,0,,,,,,,,,,
Dutch irish,0,0,0,0,1,0,0,0,,,,,,,,,,
"Dutch, British",1,1,0,0,1,0,0,0,,,,,,,,,,
"Dutch, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"Dutch, Irish, Japanese",0,0,0,0,1,1,0,0,,,,,,,,,,
"Dutch, Scottish, Welsh",0,1,0,1,1,0,0,1,,,,,,,,,,
ENGLISH,0,0,0,0,1,0,0,0,,,,,,,,,,
ENGLISH,0,1,0,0,1,0,0,0,,,,,,,,,,
Eastern European,0,0,0,0,1,0,0,0,,,,,,,,,,
England/Scotland,0,1,0,0,1,0,0,0,,,,,,,,,,
Englis,0,1,0,0,1,0,0,0,,,,,,,,,,
English,0,0,0,0,1,0,0,0,,,,,,,,,,
English,0,0,0,0,1,0,1,0,,,,,,,,,,
English,0,0,0,0,1,1,0,0,,,,,,,,,,
English,0,1,0,0,1,0,0,0,,,,,,,,,,
English,0,1,0,0,1,0,0,1,,,,,,,,,,
English,0,1,0,0,1,0,1,0,,,,,,,,,,
English,1,0,0,0,0,0,0,0,,,,,,,,,,
English,1,0,0,0,1,0,0,0,,,,,,,,,,
English,1,0,0,1,1,1,0,0,,,,,,,,,,
English,1,1,0,0,1,0,0,0,,,,,,,,,,
English,1,1,0,0,1,1,0,0,,,,,,,,,,
English,1,1,0,1,1,0,0,0,,,,,,,,,,
English German,0,0,0,0,1,0,0,0,,,,,,,,,,
English Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
English Scottish Irish French,0,0,0,0,1,0,0,0,,,,,,,,,,
English and German,0,0,0,0,1,0,0,0,,,,,,,,,,
English with mix of Scandinavian and Iberia alongside my Hispanic ethnicity,0,1,0,0,1,0,0,0,,,,,,,,,,
"English, Bohemian, Slovenian,",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Czech, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, French, Spanish",0,1,0,0,1,0,0,0,,,,,,,,,,
"English, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, German",0,0,0,1,1,1,0,0,,,,,,,,,,
"English, German, Irish, Native American",0,0,0,0,1,0,0,0,,,,1,,,,,,
"English, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish",1,0,0,0,1,1,0,0,,,,,,,,,,
"English, Irish,",0,0,0,0,1,1,0,0,,,,,,,,,,
"English, Irish, American Indian",0,0,0,0,1,0,0,0,,,,1,,,,,,
"English, Irish, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, German, French, Italian, Switzerland, Bulgaria, Romania, Russia, Sweden, Norway, Iceland, Greece.",1,0,0,1,1,1,1,0,,,,,,,,,,
"English, Irish, German, Spanish",0,1,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, Scottish",0,1,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, Scottish, German, Ukrainian, polish",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, Scottish, Spanish, and Portuguese",0,1,0,1,1,0,0,0,,,,,,,,,,
"English, Irish, Slavic, Italian, Dutch and german",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, Swedish",0,1,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, and German",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, french",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Irish, german",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Italian, German, Irish, Spanish",1,1,0,1,1,0,0,0,,,,,,,,,,
"English, Norwegian",0,0,0,0,1,1,0,0,,,,,,,,,,
"English, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Scottish, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Scottish, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Scottish, Welch, Dutch and Polish",0,0,0,0,1,1,0,0,,,,,,,,,,
"English, Scottish, Welsh",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, Welsh, Scots, Irish, French, German, Dutch",0,0,0,0,1,0,0,0,,,,,,,,,,
"English, irish",0,0,0,0,1,0,0,1,,,,,,,,,,
"English, italian",0,0,0,0,1,1,0,0,,,,,,,,,,
"English,Irish,German",0,0,0,0,1,0,0,0,,,,,,,,,,
English/French,0,0,0,0,1,0,0,0,,,,,,,,,,
English/Norwegian,0,0,0,0,1,0,0,0,,,,,,,,,,
English/Scottish,0,0,0,0,1,0,0,0,,,,,,,,,,
European,0,0,0,0,1,0,0,0,,,,,,,,,,
European,0,1,0,0,1,0,0,0,,,,,,,,,,
European,0,1,0,0,1,0,0,1,,,,,,,,,,
European/British,0,1,0,0,1,0,0,1,,,,,,,,,,
Finish,0,0,0,0,1,0,0,0,,,,,,,,,,
Finn/Norwegian,0,0,0,0,1,0,0,0,,,,,,,,,,
Finnish,0,1,0,0,1,0,0,0,,,,,,,,,,
Finnish,1,1,0,0,1,0,0,0,,,,,,,,,,
First generation Cuban,0,1,0,0,1,0,0,0,,,,,,,,,,
French,0,0,0,0,1,0,0,0,,,,,,,,,,
French,0,0,0,0,1,1,0,0,,,,,,,,,,
French,0,1,0,0,1,0,0,0,,,,,,,,,,
French Canadian,0,0,0,0,1,0,0,0,,,,,,,,,,
"French, German, Irish, Spanish",0,1,0,0,1,0,0,0,,,,,,,,,,
"French, Italian, British, Irish",0,0,0,1,1,0,0,0,,,,,,,,,,
"French, Italian, Scottish, Spanish",0,1,0,0,1,1,0,0,,,,,,,,,,
French-Scottish,0,0,0,0,1,0,0,0,,,,,,,,,,
French/Dutch/Spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
From mother's side via slavery.,1,0,0,0,1,1,0,1,,,,,,,,,,
GERMAN INDIAN,0,0,0,0,1,0,0,0,,,,,,,,,,
"GERMAN.DUTCH,ENGLISH",0,0,0,0,1,0,0,0,,,,,,,,,,
"Germain, French",0,0,0,0,1,0,0,0,,,,,,,,,,
German,0,0,0,0,1,0,0,0,,,,,,,,,,
German,0,0,0,0,1,1,0,0,,,,,,,,,,
German,0,1,0,0,1,0,0,0,,,,,,,,,,
German,0,1,0,1,1,0,0,0,,,,,,,,,,
German,1,0,0,0,1,0,0,0,,,,,,,,,,
German & French,0,0,0,0,1,0,0,0,,,,,,,,,,
German & Irish,0,1,0,1,1,0,0,0,,,,,,,,,,
German & Irish,1,0,0,0,1,1,0,0,,,,,,,,,,
German & Mexican,0,1,0,0,1,0,0,0,,,,,,,,,,
German Dutch,0,1,0,0,1,0,0,0,,,,,,,,,,
German French and Cherokee and Irish,0,0,0,1,1,0,0,0,,,,,,,,,,
German Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
German Irish French Canadian,0,0,0,0,1,0,0,0,,,,,,,,,,
German Irish Italian,0,0,0,0,1,0,0,0,,,,,,,,,,
German Irish Russian English,0,0,0,0,1,0,1,0,,,,,,,,,,
German Irish Scottish,0,0,0,0,1,1,1,0,,,,,,,,,,
German Irish Spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
German Swedish,0,0,0,0,1,0,0,0,,,,,,,,,,
German Swiss,0,0,0,0,1,0,0,0,,,,,,,,,,
German and Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
German and italian,0,0,0,0,1,0,0,0,,,,,,,,,,
German jewish,0,0,0,0,1,0,0,0,,,,,,,,,,
German mutt,0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Bohemian, Polish, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Czech",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Dutch, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, English",0,0,0,0,1,1,0,0,,,,,,,,,,
"German, English, Danish, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, English, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, English, Irish, Scottish, Swedish, Swiss",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, English, basic white",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, English, etc.",0,0,0,0,1,1,0,0,,,,,,,,,,
"German, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, French",0,1,0,0,1,0,0,0,,,,,,,,,,
"German, French, Irish",0,1,0,1,1,0,0,1,,,,,,,,,,
"German, French, Irish, Italian",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish",0,0,0,1,1,1,0,0,,,,,,,,,,
"German, Irish",0,1,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, English",0,1,0,0,1,0,0,1,,,,,,,,,,
"German, Irish, English, Dutch, Italian, Portuguese",1,1,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, English, Italian, British, Scottish, Welsh",1,1,0,1,1,1,0,1,,,,,,,,,,
"German, Irish, English, Italian, Greek, Scotch, Swedish, Norwegian, Israeli, Iranian, Slavic,",0,1,0,1,1,1,0,1,,,,,,,,,1,
"German, Irish, English, Portuguese, Scottish, Dutch",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, English, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, French, English",0,0,0,1,1,1,0,0,,,,,,,,,,
"German, Irish, Polish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, Polish, Swedish, Italian",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Irish, Scottish",0,0,0,0,1,1,0,0,,,,,,,,,,
"German, Irish, Swede",0,0,0,0,1,1,0,0,,,,,,,,,,
"German, Italian",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Lithuanian",0,1,0,0,1,0,0,0,,,,,,,,,,
"German, Norwegian, English",0,1,0,1,1,0,0,0,,,,,,,,,,
"German, Polish, Jewish",0,1,0,1,1,0,0,0,,,,,,,,,,
"German, Scots-Irish",0,0,0,1,1,1,0,0,,,,,,,,,,
"German, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Scottish",0,1,0,0,1,0,0,0,,,,,,,,,,
"German, Scottish, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Ukrainian, and Welsh",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, Welsh, Irish",0,0,0,0,1,1,0,0,,,,,,,,,,
"German, Welsh, Norwegian",0,0,0,0,1,1,0,0,,,,,,,,,,
"German, french, irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German, swedish",0,0,0,0,1,0,0,0,,,,,,,,,,
"German,Irish,French,Dutch",0,0,0,0,1,0,0,0,,,,,,,,,,
"German,Italian, Irish",0,0,0,0,1,1,0,0,,,,,,,,,,
"German,Welsh, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"German,english",0,0,0,0,1,0,0,0,,,,,,,,,,
German-Dutch,0,0,0,0,1,0,0,0,,,,,,,,,,
German-Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
German-Norwegian,0,0,0,0,1,0,0,0,,,,,,,,,,
"German-Russian, British, Scott, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
German. Spaniard,0,1,0,0,1,0,0,0,,,,,,,,,,
"German., Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
German/Austria,0,0,0,0,1,0,0,0,,,,,,,,,,
German/English/French,0,0,0,0,1,0,0,0,,,,,,,,,,
German/French as far as I know.,0,0,0,0,1,0,0,0,,,,,,,,,,
German/Irish/Polish,0,0,0,0,1,0,0,0,,,,,,,,,,
"Germanic European, northwest European",0,0,0,0,1,0,0,0,,,,,,,,,,
Greek,0,0,0,0,1,0,0,0,,,,,,,,,,
Greek American,0,0,0,0,1,0,0,0,,,,,,,,,,
Guatemalan,0,1,0,0,1,0,0,0,,,,,,,,,,
Half Caucasian - a little bit of everything western European,0,0,0,0,1,1,0,0,,,,,,,,,,
Here,0,1,0,0,1,0,0,0,,,,,,,,,,
Hispanic,0,1,0,0,1,0,0,0,,,,,,,,,,
Hispanic and Dutch mix,0,1,0,0,1,0,0,0,,,,,,,,,,
Hungarian,0,0,0,0,1,0,0,0,,,,,,,,,,
Hungarian,0,0,0,0,1,1,0,0,,,,,,,,,,
Hungarian,0,1,0,0,1,0,0,0,,,,,,,,,,
I am American and am descended from many different groups,0,0,0,0,1,0,0,0,,,,,,,,,,
I don't know,0,0,0,0,1,0,0,0,,,,,,,,,,
I dont know,0,1,0,0,1,0,0,0,,,,,,,,,,
"I don�t look white, but on my birth certificate, I�m listed as Caucasian.",0,1,0,0,1,0,0,0,,,,,,,,,,
I'm a mix but more like white,0,1,0,1,1,0,0,0,,,,,,,,,,
IRISH,0,0,0,0,1,0,0,0,,,,,,,,,,
"IRISH, ENGLISH, GERMAN, FINNISH, HUNGARIAN",0,0,0,0,1,0,0,0,,,,,,,,,,
Iberian,0,1,0,0,1,0,0,0,,,,,,,,,,
Im a very white girl. I got lots of german in my blood,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish,0,0,0,0,1,1,0,0,,,,,,,,,,
Irish,0,0,0,1,1,1,0,0,,,,,,,,,,
Irish,0,1,0,0,1,0,0,0,,,,,,,,,,
Irish,0,1,0,1,1,0,0,1,,,,,,,,,,
Irish,1,0,0,0,1,0,0,0,,,,,,,,,,
Irish American,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish English,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish English Dutch check,1,0,0,0,1,0,0,0,,,,,,,,,,
Irish German,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish Portuguese Ethiopian,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish Spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
Irish and English,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish and french,0,0,0,0,1,1,0,0,,,,,,,,,,
Irish and italian,0,1,0,0,1,0,0,0,,,,,,,,,,
"Irish, Austrian, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, British, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, English, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, English, French, German",1,0,0,0,1,1,0,0,,,,,,,,,,
"Irish, English, German",0,0,0,1,1,1,0,0,,,,,,,,,,
"Irish, English, German, French",0,0,0,0,1,1,1,0,,,,,,,,,,
"Irish, English, German, Lithuanian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, English, Native American",0,0,0,0,1,0,0,0,,,,1,,,,,,
"Irish, English, Scottish, Welch",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, English, Welsh",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, English, scotch, dutch",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, French",1,1,0,0,1,0,0,0,,,,,,,,,,
"Irish, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, German, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, German, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, German, French",0,1,0,0,1,0,0,0,,,,,,,,,,
"Irish, German, Welsch",0,0,0,0,1,1,0,0,,,,,,,,,,
"Irish, Italian, Greek, Dutch, German",0,0,0,0,1,1,0,0,,,,,,,,,,
"Irish, Italian, Ukrainian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, Polish",0,1,0,0,1,0,0,0,,,,,,,,,,
"Irish, Scots, British, German",0,0,0,0,1,1,0,0,,,,,,,,,,
"Irish, Scottish",1,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, Scottish, Hungarian, Croatian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, Ukrainian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Irish, swedish",0,1,0,1,1,0,0,0,,,,,,,,,,
"Irish, welsh, English",0,1,0,0,1,0,0,0,,,,,,,,,,
"Irish,dutch",0,0,0,0,1,1,0,0,,,,,,,,,,
"Irish,english",0,0,0,0,1,0,0,0,,,,,,,,,,
Irish-Italian,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish-Mexican,0,1,0,0,1,0,0,0,,,,,,,,,,
Irish/Danish,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish/English,0,0,0,0,1,0,0,0,,,,,,,,,,
Irish/Iralian,0,0,0,0,1,0,0,0,,,,,,,,,,
Italia,0,0,0,0,1,0,0,0,,,,,,,,,,
Italian,0,0,0,0,1,0,0,0,,,,,,,,,,
Italian,0,0,0,0,1,1,0,0,,,,,,,,,,
Italian,0,1,0,0,1,0,0,0,,,,,,,,,,
Italian,0,1,0,0,1,0,0,1,,,,,,,,,,
Italian,0,1,0,1,1,0,0,0,,,,,,,,,,
Italian from farther side,0,1,0,0,1,0,0,0,,,,,,,,,,
"Italian, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"Italian, Hungarian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Italian, Irish, Scot",0,0,0,0,1,0,0,0,,,,,,,,,,
"Italian, Norwegian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Italian, Polish, Russian",0,0,0,0,1,1,0,0,,,,,,,,,,
"Italian, Portuguese, and Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Italian, Scottish",0,0,0,0,1,0,0,0,,,,,,,,,,
"Italian, Swedish,English",0,1,0,0,1,0,0,0,,,,,,,,,,
Italian- Hungarian,0,0,0,0,1,0,0,0,,,,,,,,,,
Italian/Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
Italian/Polish/eastern Europe,0,0,0,0,1,0,0,0,,,,,,,,,,
Italiano,0,1,0,0,1,0,0,0,,,,,,,,,,
Last of Hitler's Aryans,0,0,0,0,1,0,0,0,,,,,,,,,,
Latin,0,1,0,0,1,0,0,0,,,,,,,,,,
Latina,0,1,0,0,1,0,0,0,,,,,,,,,,
Latino,0,1,0,0,1,0,0,0,,,,,,,,,,
Latinos usuall fall under this on offical documents but I am not white,0,1,0,0,1,0,0,0,,,,,,,,,,
Lebanese,0,1,0,0,1,0,0,0,,,,,,,,,1,
Lebanon,0,0,0,0,1,0,0,0,,,,,,,,,1,
Mestizo.,0,1,0,0,1,0,0,0,,,,,,,,,,
Mexican,0,1,0,0,1,0,0,0,,,,,,,,,,
Mexican American ,0,1,0,0,1,0,0,0,,,,,,,,,,
Mexican American,0,1,0,0,1,0,0,0,,,,,,,,,,
Mexican Irish Welsh,0,1,0,0,1,0,0,0,,,,,,,,,,
"Mexican, German, Irish",0,1,0,1,1,0,0,0,,,,,,,,,,
"Mexican, German, Polish, Czech",0,1,0,0,1,0,0,0,,,,,,,,,,
"Mexican, German, english",0,0,0,0,1,0,0,0,,,,,,,,,,
Mexicana,0,1,0,0,1,0,0,0,,,,,,,,,,
Mexico,0,1,0,0,1,0,0,0,,,,,,,,,,
Mix of multiple European ethnicities,0,1,0,0,1,0,0,0,,,,,,,,,,
"Mix, mostly Northern European",0,0,0,0,1,0,0,0,,,,,,,,,,
Mixed,0,0,0,0,1,0,0,0,,,,,,,,,,
Mother lose white,1,0,0,0,1,0,0,0,,,,,,,,,,
Mulatto great grandparents,1,0,0,1,1,0,0,0,,,,,,,,,,
Mutt,0,0,0,0,1,0,0,0,,,,,,,,,,
My mother is white and my father is Puerto Rican,0,1,0,0,1,0,0,0,,,,,,,,,,
Nit sure,0,1,0,0,1,0,0,0,,,,,,,,,,
"Norwegian, Italian, Irish, Turkish",0,1,0,0,1,0,0,0,,,,,,,,,,
Norwegian/German/Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
Not sure,0,0,0,0,1,0,0,0,,,,,,,,,,
Not sure,0,1,0,0,1,0,0,0,,,,,,,,,,
Of Puerto Rican descent,0,1,0,0,1,0,0,0,,,,,,,,,,
POLISH,0,0,0,0,1,0,0,0,,,,,,,,,,
Peru,0,1,0,0,1,0,0,0,,,,,,,,,,
Polish,0,0,0,0,1,0,0,0,,,,,,,,,,
Polish,0,0,0,0,1,1,0,0,,,,,,,,,,
Polish,0,1,0,0,1,0,0,0,,,,,,,,,,
Polish and German,0,0,0,0,1,0,0,0,,,,,,,,,,
"Polish, Irish, Italian",0,0,0,0,1,0,0,0,,,,,,,,,,
"Polish, Russian",1,1,0,1,1,0,0,0,,,,,,,,,,
"Polish, Slovak, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
Polish-Ukrainian,0,0,0,0,1,0,0,0,,,,,,,,,,
Portugues,0,0,0,0,1,1,0,0,,,,,,,,,,
Portuguese,0,0,0,0,1,1,0,0,,,,,,,,,,
Portuguese,0,1,0,0,1,0,0,0,,,,,,,,,,
"Portuguese, German, Native American",0,0,0,0,1,0,0,0,,,,1,,,,,,
Predominantly German and Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
Pride of being an American,0,0,0,0,1,0,0,0,,,,,,,,,,
Puerto Rican,0,1,0,0,1,0,0,0,,,,,,,,,,
Puerto Rican/white mix,0,1,0,0,1,0,0,0,,,,,,,,,,
"Romanian, French",0,0,0,0,1,0,0,0,,,,,,,,,,
"Romanian, Lebanese, Egyptian",0,0,0,0,1,1,0,0,,,,,,,,,1,
Russian,0,0,0,0,1,0,0,0,,,,,,,,,,
Russian,0,1,0,0,1,0,0,0,,,,,,,,,,
Russian,1,0,0,0,1,1,0,0,,,,,,,,,,
Russian & Polish,0,0,0,0,1,0,0,0,,,,,,,,,,
Russian/Armenian,0,0,0,0,1,0,0,0,,,,,,,,,,
SCOTTISH,0,0,0,0,1,1,0,0,,,,,,,,,,
SPAIN,0,1,0,0,1,0,0,0,,,,,,,,,,
Scandinavian,0,0,0,0,1,1,0,0,,,,,,,,,,
"Scandinavian, Celtic mix",0,0,0,0,1,0,0,0,,,,,,,,,,
Scot,0,0,0,0,1,0,0,0,,,,,,,,,,
Scot / M exican,0,1,0,0,1,0,0,0,,,,,,,,,,
"Scot, Irish. German, LowLands",0,0,0,0,1,0,0,0,,,,,,,,,,
"Scotch, Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
Scotch-Irish and German,0,0,0,0,1,0,0,0,,,,,,,,,,
Scotch/Irish,0,1,0,0,1,0,0,0,,,,,,,,,,
Scots-Irish,0,0,0,1,1,1,0,0,,,,,,,,,,
"Scots-Irish, French, plus",0,0,0,0,1,0,0,0,,,,,,,,,,
Scottish,0,0,0,0,1,0,0,0,,,,,,,,,,
Scottish,0,1,0,0,1,0,0,0,,,,,,,,,,
Scottish,1,0,0,0,1,1,0,0,,,,,,,,,,
Scottish,1,1,0,1,1,1,0,0,,,,,,,,,,
Scottish & Irish,0,0,0,0,1,0,0,0,,,,,,,,,,
Scottish and Irish and Welsh,0,0,0,0,1,1,0,0,,,,,,,,,,
"Scottish, Hungarian",0,0,0,0,1,1,0,0,,,,,,,,,,
"Scottish, Irish, Norwegian, German",0,1,0,0,1,0,0,1,,,,,,,,,,
"Scottish, german",0,0,0,0,1,0,0,0,,,,,,,,,,
Sicilian,0,1,0,0,1,0,0,0,,,,,,,,,,
Sicilian Irish french,0,0,0,0,1,0,0,0,,,,,,,,,,
"Sicilian, Irish, and French Canadian.",0,0,0,0,1,0,0,0,,,,,,,,,,
"Sicilian, Scottish",0,0,0,0,1,1,0,0,,,,,,,,,,
Slovenian,0,0,0,0,1,0,0,0,,,,,,,,,,
Space is redundant,0,0,0,0,1,0,0,0,,,,,,,,,,
Spain,0,1,0,0,1,0,0,0,,,,,,,,,,
"Spain, Italy",0,1,0,0,1,0,0,0,,,,,,,,,,
Spaniard,0,1,0,0,1,0,0,0,,,,,,,,,,
Spaniard and French,0,1,0,0,1,0,0,0,,,,,,,,,,
"Spaniard, German",1,1,0,1,1,0,0,0,,,,,,,,,,
"Spaniard, Portuguese",0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish,0,0,0,0,1,0,0,0,,,,,,,,,,
Spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish,0,1,0,0,1,0,0,1,,,,,,,,,,
Spanish,0,1,0,1,1,0,0,0,,,,,,,,,,
Spanish,1,1,0,1,1,0,0,0,,,,,,,,,,
Spanish / Portuguese,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish Basque,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish Descendant,0,1,0,0,1,0,0,0,,,,,,,,,,
Spanish and Irish,0,1,0,0,1,0,0,0,,,,,,,,,,
"Spanish, Cuban",0,1,0,0,1,0,0,0,,,,,,,,,,
"Spanish, English",0,1,0,0,1,0,0,0,,,,,,,,,,
"Spanish, Irish",0,1,0,0,1,0,0,0,,,,,,,,,,
"Spanish, Irish, English, Czech,",0,1,0,0,1,0,0,0,,,,,,,,,,
"Spanush, Cherokee Indian, Sicilian",0,1,0,0,1,0,0,0,,,,1,,,,,,
Swedish,0,0,0,0,1,0,0,0,,,,,,,,,,
Swedish,0,1,0,1,1,0,0,0,,,,,,,,,,
Swedish mixed races,0,0,0,0,1,0,0,0,,,,,,,,,,
"Swedish, Polish, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"Swiss, German, french",0,0,0,0,1,0,0,0,,,,,,,,,,
Swiss- German,0,0,0,0,1,0,0,0,,,,,,,,,,
Texan!,0,0,0,0,1,0,0,0,,,,,,,,,,
URUGUAY,0,1,0,0,1,0,0,0,,,,,,,,,,
USA,0,1,0,0,1,0,0,0,,,,,,,,,,
Ukrainian,0,0,0,0,1,0,0,0,,,,,,,,,,
"Ukrainian, German, English",0,0,0,0,1,0,0,0,,,,,,,,,,
"Ukrainian, Slovenian, Ashkenazi",0,0,0,0,1,0,0,0,,,,,,,,,,
United States,0,0,0,0,1,0,0,0,,,,,,,,,,
Unk,1,1,0,0,1,0,0,0,,,,,,,,,,
Unknown,0,0,0,0,1,0,0,0,,,,,,,,,,
Usa,0,1,0,0,1,0,0,0,,,,,,,,,,
Various,0,0,0,0,1,0,0,0,,,,,,,,,,
Venezuelan,0,1,0,0,1,0,0,0,,,,,,,,,,
Vhbb,0,1,0,0,1,0,0,0,,,,,,,,,,
Welsh,0,0,0,0,1,0,0,0,,,,,,,,,,
Welsh,0,0,0,0,1,1,0,0,,,,,,,,,,
"Welsh, English",0,1,0,0,1,0,0,0,,,,,,,,,,
"Welsh, English, German",0,0,0,0,1,0,0,0,,,,,,,,,,
"Welsh, German",0,1,0,0,1,0,0,0,,,,,,,,,,
"Welsh, Scottish",0,0,0,1,1,1,0,0,,,,,,,,,,
"Welsh,Scottish,Mexican",0,1,0,0,1,0,0,0,,,,,,,,,,
Welsh/polish,0,0,0,0,1,0,0,0,,,,,,,,,,
Western European & Mediterranean,1,1,0,1,1,0,0,0,,,,,,,,,,
"Western European, maybe Scottish or Irish",0,0,0,0,1,0,0,0,,,,,,,,,,
Western/Eastern European-Middle Eastern,1,1,0,1,1,1,0,0,,,,,,,,,1,
White,0,0,0,0,1,0,0,0,,,,,,,,,,
White,0,0,0,0,1,1,0,0,,,,,,,,,,
White,0,1,0,0,1,0,0,0,,,,,,,,,,
"White - Scottish, French, Swedish",0,0,0,0,1,0,0,0,,,,,,,,,,
White and Hispanic,0,1,0,0,1,0,0,0,,,,,,,,,,
White hispanic,0,1,0,0,1,0,0,0,,,,,,,,,,
american,0,0,0,0,1,1,0,0,,,,,,,,,,
american / welsh,0,0,0,0,1,0,0,0,,,,,,,,,,
argentina,0,1,0,0,1,0,0,0,,,,,,,,,,
argentinian,0,1,0,0,1,0,0,0,,,,,,,,,,
caucasin,0,0,0,0,1,0,0,0,,,,,,,,,,
colombian,0,1,0,0,1,0,0,0,,,,,,,,,,
cuban,0,1,0,0,1,0,0,0,,,,,,,,,,
cubana,0,1,0,0,1,0,0,0,,,,,,,,,,
english,0,0,0,0,1,0,0,0,,,,,,,,,,
english,0,0,0,0,1,0,1,0,,,,,,,,,,
english,0,0,0,0,1,1,0,0,,,,,,,,,,
english,0,1,0,0,1,0,0,0,,,,,,,,,,
english & polish,0,0,0,0,1,0,0,0,,,,,,,,,,
english and swedish,0,0,0,0,1,0,0,0,,,,,,,,,,
english irish,0,0,0,1,1,1,0,0,,,,,,,,,,
french canadien,0,0,0,0,1,0,0,0,,,,,,,,,,
g,0,0,0,0,1,0,0,0,,,,,,,,,,
geerman,0,0,0,0,1,0,0,0,,,,,,,,,,
german,0,0,0,0,1,0,0,0,,,,,,,,,,
german,0,1,0,0,1,0,0,0,,,,,,,,,,
"german , italian",0,0,0,0,1,0,0,0,,,,,,,,,,
german english,0,0,0,0,1,0,0,0,,,,,,,,,,
german italian,0,0,0,0,1,1,0,0,,,,,,,,,,
"german, dutch",0,0,0,0,1,1,0,1,,,,,,,,,,
"german, english",1,1,0,1,1,0,0,0,,,,,,,,,,
"german, english, french, norway",0,0,0,0,1,0,0,0,,,,,,,,,,
"german, irish, english, polish",0,0,0,0,1,0,0,0,,,,,,,,,,
"german, scottish, french",0,0,0,0,1,0,0,0,,,,,,,,,,
"german,rushen",0,0,0,0,1,0,0,0,,,,,,,,,,
german/french,0,0,0,0,1,0,0,0,,,,,,,,,,
half English,0,0,0,0,1,0,0,0,,,,,,,,,,
hispanic,0,1,0,0,1,0,0,0,,,,,,,,,,
irish,0,0,0,0,1,0,0,0,,,,,,,,,,
irish,0,0,0,0,1,1,0,0,,,,,,,,,,
irish,0,1,0,0,1,0,0,0,,,,,,,,,,
irish,1,0,0,1,1,1,0,0,,,,,,,,,,
irish,1,1,0,1,1,0,0,0,,,,,,,,,,
irish english,0,0,0,0,1,0,0,0,,,,,,,,,,
"irish, german",0,0,0,0,1,0,0,0,,,,,,,,,,
italian,0,0,0,0,1,0,0,0,,,,,,,,,,
italian,0,0,0,0,1,1,0,0,,,,,,,,,,
italian,0,1,0,0,1,0,0,0,,,,,,,,,,
italian,0,1,0,0,1,0,0,1,,,,,,,,,,
italian,1,1,0,1,1,0,0,0,,,,,,,,,,
latin american,0,1,0,0,1,0,0,0,,,,,,,,,,
many many,0,0,0,0,1,0,0,0,,,,,,,,,,
mexican,0,1,0,0,1,0,0,0,,,,,,,,,,
mexican american,0,1,0,0,1,0,0,0,,,,,,,,,,
mixed,0,0,0,0,1,0,0,0,,,,,,,,,,
none,0,1,0,0,1,0,0,0,,,,,,,,,,
not sure,0,0,0,0,1,0,0,0,,,,,,,,,,
not sure,0,1,0,0,1,0,0,0,,,,,,,,,,
polish,0,0,0,0,1,0,0,0,,,,,,,,,,
"polish, german, irish",0,0,0,0,1,0,0,0,,,,,,,,,,
slavic,0,0,0,0,1,0,0,0,,,,,,,,,,
slovak,0,0,0,0,1,0,0,0,,,,,,,,,,
spanish,0,1,0,0,1,0,0,0,,,,,,,,,,
spanish,0,1,0,0,1,0,0,1,,,,,,,,,,
"spanish, maybe",0,1,0,0,1,0,0,0,,,,,,,,,,
unknown,0,1,0,0,1,0,0,0,,,,,,,,,,
usa,0,0,0,0,1,0,0,0,,,,,,,,,,
"welsh,english, german, french",0,0,0,0,1,0,0,0,,,,,,,,,,
white,0,0,0,0,1,0,0,0,,,,,,,,,,
white,0,1,0,0,1,0,0,0,,,,,,,,,,
run;

*Black , Seperate treatment;
data f2b_2_t;
	length f2b_2_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2b_2_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
77% ancestry,1,0,0,1,1,0,0,0,,,,,,,,,,
African,1,0,0,0,0,0,0,0,,,,,,,,,,
African,1,1,0,0,0,0,0,0,,,,,,,,,,
African Am,1,0,0,0,0,0,0,0,,,,,,,,,,
African Am.,1,0,0,0,0,0,0,0,,,,,,,,,,
African America,1,0,0,0,0,0,0,0,,,,,,,,,,
African American,1,0,0,0,0,0,0,0,,,,,,,,,,
African American,1,0,0,0,0,1,0,0,,,,,,,,,,
African American,1,0,0,0,1,0,0,0,,,,,,,,,,
African American,1,0,0,0,1,1,0,0,,,,,,,,,,
African American,1,0,0,1,1,1,0,0,,,,,,,,,,
African American,1,1,0,0,0,0,0,0,,,,,,,,,,
African American,1,1,0,1,1,0,0,0,,,,,,,,,,
African American,1,1,0,1,1,1,0,0,,,,,,,,,,
African American,1,1,0,1,1,1,0,1,,,,,,,,,,
African Americans,1,0,0,0,0,0,0,0,,,,,,,,,,
African amari an,1,0,0,0,0,0,0,0,,,,,,,,,,
African american,1,0,0,0,0,0,0,0,,,,,,,,,,
African amserican,1,0,0,0,1,0,0,0,,,,,,,,,,
African-American,1,0,0,0,0,0,0,0,,,,,,,,,,
African-American,1,1,0,0,0,0,0,0,,,,,,,,,,
African-American,1,1,0,1,0,0,0,0,,,,,,,,,,
Afro-Colombian,1,1,0,1,1,0,0,0,,,,,,,,,,
American,1,0,0,0,0,0,0,0,,,,,,,,,,
American,1,0,0,1,0,0,0,0,,,,,,,,,,
American Indian,1,0,0,1,1,0,0,0,,,,,,,,,,
American black,1,1,0,0,0,0,0,0,,,,,,,,,,
American descendant of racially enslaved people,1,0,0,0,0,0,0,0,,,,,,,,,,
BLACK AMERICAN,1,0,0,0,0,0,0,0,,,,,,,,,,
Black,1,0,0,0,0,0,0,0,,,,,,,,,,
Black,1,0,0,0,0,1,0,0,,,,,,,,,,
Black African,1,0,0,0,0,0,0,0,,,,,,,,,,
Black America,1,0,0,0,0,0,0,0,,,,,,,,,,
Black American,1,0,0,0,0,0,0,0,,,,,,,,,,
Black American,1,1,0,0,1,0,0,0,,,,,,,,,,
Black Creole American,1,0,0,0,0,1,0,0,,,,,,,,,,
Black american,1,0,0,0,0,0,0,0,,,,,,,,,,
Blk,1,0,0,0,0,0,0,0,,,,,,,,,,
Blk,1,1,0,0,0,0,0,0,,,,,,,,,,
Cameroon,1,0,0,0,0,0,0,0,,,,,,,,,,
Cape Verde,1,1,0,0,0,0,0,0,,,,,,,,,,
Creole,1,0,0,0,0,0,0,0,,,,,,,,,,
Descendent of enslaved,1,0,0,0,0,0,0,0,,,,,,,,,,
Dominican,1,1,0,1,1,0,0,0,,,,,,,,,,
Ethiopian,1,0,0,0,0,0,0,0,,,,,,,,,,
Father is black so I can be white or black,1,0,0,0,1,0,0,0,,,,,,,,,,
French and German,1,0,0,0,0,0,0,0,,,,,,,,,,
Haitian,1,0,0,0,0,0,0,0,,,,,,,,,,
Haitian,1,0,0,0,1,0,0,0,,,,,,,,,,
"Haitian, Nigerian",1,0,0,0,0,0,0,0,,,,,,,,,,
Hindu-Carribean,1,1,0,1,1,1,0,0,,,,,,,,,,
Jamaican,1,0,0,0,0,0,0,0,,,,,,,,,,
Jamaican,1,0,0,0,0,1,0,0,,,,,,,,,,
Jamaican,1,1,0,0,0,0,0,0,,,,,,,,,,
Jamaican,1,1,0,0,1,0,0,0,,,,,,,,,,
"Libya, Ivory Coast.",1,0,0,1,1,1,1,0,,,,,,,,,1,
Mixed Black American,1,0,0,0,0,1,0,0,,,,,,,,,,
"My African heritage is all over the West Coast of Africa from both sides. Also some from East, mid, South and north Africa.",1,0,0,0,1,1,0,1,,,,,,,,,,
My Grandfather is a Nigerian,1,0,0,0,0,0,0,0,,,,,,,,,,
N. African,1,1,0,0,1,0,0,0,,,,,,,,,,
N/A,1,0,0,0,0,0,0,0,,,,,,,,,,
Na,1,0,0,0,0,0,0,0,,,,,,,,,,
Nigeria,1,0,0,0,0,0,0,0,,,,,,,,,,
Nigerian,1,0,0,0,0,0,0,0,,,,,,,,,,
Nigerian American,1,0,0,0,0,0,0,0,,,,,,,,,,
Nigerian and African American,1,0,0,0,0,0,0,0,,,,,,,,,,
Nigerian decendant,1,0,0,0,0,0,0,0,,,,,,,,,,
"Nigerian, African American",1,1,0,0,1,0,0,0,,,,,,,,,,
"Nigerian, Ghanan, Liberian, Sierra Leonan, Senagambian",1,0,0,0,1,1,0,0,,,,,,,,,,
Senegalese,1,1,0,0,1,1,0,0,,,,,,,,,,
Sengalese,1,0,0,0,1,1,0,0,,,,,,,,,,
Somali,1,0,0,0,0,0,0,0,,,,,,,,,,
South Africa,1,0,0,0,0,0,0,0,,,,,,,,,,
South African,1,1,0,0,0,0,0,0,,,,,,,,,,
USA,1,0,0,0,0,0,0,1,,,,,,,,,,
Unknown,1,0,0,0,0,0,0,0,,,,,,,,,,
Unknown,1,1,0,1,1,0,0,0,,,,,,,,,,
West African (unknown),1,1,0,1,1,0,0,0,,,,,,,,,,
West Indies,1,0,0,0,0,0,0,0,,,,,,,,,,
african american,1,0,0,0,0,0,0,0,,,,,,,,,,
african american,1,1,0,1,1,0,0,0,,,,,,,,,,
afro-amer.,1,0,0,0,0,0,0,0,,,,,,,,,,
black,1,0,0,0,0,0,0,0,,,,,,,,,,
i am african american,1,0,0,0,0,0,0,0,,,,,,,,,,
niger,1,0,0,0,0,0,0,0,,,,,,,,,,
nigeria,1,1,0,1,1,0,0,0,,,,,,,,,,
yoruba,1,0,0,1,1,1,0,0,,,,,,,,,,
run;

*Asian, Seperate treatment;
data f2b_13_t;
	length f2b_13_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2b_13_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
Afghani,0,0,0,0,0,1,0,0,,,,,,,,,,
Afghanistani,0,0,0,0,0,1,0,0,,,,,,,,,,
"Armanian, Indian, Georgian",0,0,0,0,1,1,0,0,,,,,,,,,,
Bangladeshi,0,0,0,0,0,1,0,0,,,,,,,,,,
Bangldeshi,0,0,0,0,0,1,0,0,,,,,,,,,,
Burmese,0,0,0,0,0,1,0,0,,,,,,,,,,
Burmese,1,1,0,0,1,1,0,0,,,,,,,,,,
Cambodian,0,0,0,0,0,1,0,0,,,,,,,,,,
Cambodian (Khmer),0,0,0,0,0,1,0,0,,,,,,,,,,
"Chinese, Southeast Asian",1,0,0,0,1,1,0,0,,,,,,,,,,
Hmong,0,0,0,0,0,1,0,0,,,,,,,,,,
Hong Kong,0,0,0,0,0,1,0,0,,,,,,,,,,
Hongkongese,0,0,0,0,0,1,0,0,,,,,,,,,,
Imdian,0,0,0,0,0,1,0,0,,,,,,,,,,
Indian,0,0,0,0,0,1,0,0,,,,,,,,,,
Indian,0,0,0,0,1,1,0,0,,,,,,,,,,
Indonesia,0,0,0,0,0,1,0,0,,,,,,,,,,
Indonesian,0,0,0,0,0,1,0,0,,,,,,,,,,
Indonesian,0,0,0,0,1,1,0,0,,,,,,,,,,
Indonesian,0,1,0,0,0,1,0,0,,,,,,,,,,
Karenni,0,0,0,0,0,1,0,0,,,,,,,,,,
Khmer,1,0,0,0,0,1,0,0,,,,,,,,,,
Lao,0,0,0,0,1,1,0,0,,,,,,,,,,
Laotian,0,0,0,0,0,1,0,0,,,,,,,,,,
Laotian,0,1,0,0,0,1,0,0,,,,,,,,,,
Malaysia,0,0,0,0,0,1,0,0,,,,,,,,,,
Malaysian,0,0,0,0,0,1,0,0,,,,,,,,,,
Many genes from middle east,1,0,0,0,1,1,0,1,,,,,,,,,1,
Mien,0,0,0,0,0,1,0,0,,,,,,,,,,
Myanmar,0,0,0,0,0,1,0,0,,,,,,,,,,
Nepalese,0,0,0,0,0,1,0,0,,,,,,,,,,
Nepali,0,0,0,0,0,1,0,0,,,,,,,,,,
Okinawan,0,0,0,0,0,1,0,0,,,,,,,,,,
Pakistan,0,0,0,0,0,1,0,0,,,,,,,,,,
"Pakistan, Khmer, Hong Kong, Malaysia, Indonesia.",1,0,0,1,1,1,1,0,,,,,,,,,,
Pakistani,0,0,0,0,0,1,0,0,,,,,,,,,,
Russian,1,1,0,1,1,1,0,1,,,,,,,,,,
Singaporean,0,0,0,0,1,1,0,0,,,,,,,,,,
South Asian (Indian),0,0,0,0,0,1,0,0,,,,,,,,,,
Spanish~Filipino~American,0,1,0,0,0,1,0,0,,,,,,,,,,
Sri Lanka,0,1,0,0,0,1,0,0,,,,,,,,,,
Taiwanese,0,0,0,0,0,1,0,0,,,,,,,,,,
Taiwanese,1,0,0,1,1,1,0,0,,,,,,,,,,
Thai,0,0,0,0,0,1,0,0,,,,,,,,,,
Thai,0,0,0,0,1,1,0,0,,,,,,,,,,
Thailand,0,0,0,0,0,1,0,0,,,,,,,,,,
bengali,0,0,0,0,0,1,0,0,,,,,,,,,,
cambodian,0,0,0,0,0,1,0,0,,,,,,,,,,
laos,0,0,0,0,0,1,0,0,,,,,,,,,,
mongolian,0,0,0,0,1,1,0,0,,,,,,,,,,
pakistani,0,0,0,0,0,1,0,0,,,,,,,,,,
taiwanese,0,0,0,0,0,1,0,0,,,,,,,,,,
taiwanese,0,0,0,0,1,1,0,0,,,,,,,,,,
west asia,0,1,0,1,1,1,0,1,,,,,,,,,,
run;

*SOR, Seperate treatment;
data f2b_15_t;
	length f2b_15_t $200;
   infile datalines delimiter=',' truncover dsd ; 
   input f2b_15_t $ Black Hisp MENA AmIndAN White Asian NHoPI SOR 
	   Black_add Hisp_add MENA_add AmIndAN_add White_add Asian_add 
	   NHoPI_add SOR_add MENA_Coded Drop_SOR
	;
   datalines;                      
African,0,1,0,0,0,0,0,1,1,,,,,,,,,1
Afro-Boricua-Taino Indian,0,1,0,0,0,0,0,1,1,,,1,,,,,,
American,0,0,0,0,0,0,0,1,,,,,,,,,,
American,0,1,0,0,0,0,0,1,,,,,,,,,,
American (all mixed up),0,0,0,0,0,0,0,1,,,,,,,,,,
American Mexican,0,1,0,0,0,0,0,1,,,,,,,,,,
American race,0,0,0,0,0,0,0,1,,,,,,,,,,
Anarchist,0,0,0,0,0,0,0,1,,,,,,,,,,
Anglo-German,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Argentinian native,0,1,0,0,0,0,0,1,,,,1,,,,,,1
Ashkeanzi,0,0,0,0,0,0,0,1,,,,,,,,,,
Ashkenazi,0,0,0,0,0,0,0,1,,,,,,,,,,
Asian American,0,0,0,0,0,1,0,1,,,,,,,,,,1
Black American,0,0,0,1,0,0,0,1,1,,,,,,,,,1
Black white,0,1,0,0,0,0,0,1,1,,,,1,,,,,1
Boricua,0,1,0,0,0,0,0,1,,,,,,,,,,
Bosnia,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Brazilian,0,0,0,0,0,0,0,1,,,,,,,,,,
Brown,0,1,0,0,0,0,0,1,,,,,,,,,,
COLOMBIAN,0,1,0,0,0,0,0,1,,,,,,,,,,
Castilian Spanish,0,1,0,1,1,0,0,1,,,,,,,,,,
Celtic,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Central American,0,1,0,0,0,0,0,1,,,,,,,,,,
Centroamerica,0,1,0,0,0,0,0,1,,,,,,,,,,
Chicano,0,1,0,0,0,0,0,1,,,,,,,,,,
Colombia,0,1,0,0,0,0,0,1,,,,,,,,,,
Colombian,0,1,0,0,0,0,0,1,,,,,,,,,,
Cuba,0,1,0,0,0,0,0,1,,,,,,,,,,
Cuban,0,1,0,0,0,0,0,1,,,,,,,,,,
DOMINICAN US,0,1,0,0,0,0,0,1,,,,,,,,,,
Decline information,0,0,0,0,0,0,0,1,,,,,,,,,,
Dominican/Carribean,0,1,0,0,0,0,0,1,,,,,,,,,,
Ecuador,0,1,0,0,0,0,0,1,,,,,,,,,,
Egyptian,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
European American,0,0,0,0,0,0,0,1,,,,,1,,,,,1
European-American,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Finnish,0,0,0,0,0,0,0,1,,,,,1,,,,,1
"Franco-Latin (Rhenish Palatinate), Quebecois, Iberian Spanish",0,1,0,1,1,0,0,1,,,,,,,,,,
HISPANIC,0,1,0,0,0,0,0,1,,,,,,,,,,
HUMAN,0,0,0,0,0,0,0,1,,,,,,,,,,
Half Italian. Half Mexican,0,1,0,0,1,0,0,1,,,,,,,,,,
Hispanic,0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanic,0,1,0,0,1,0,0,1,,,,,,,,,,
Hispanic,0,1,0,1,0,0,0,1,,,,,,,,,,
Hispanic Latino,0,1,0,0,0,0,0,1,,,,,,,,,,
"Hispanic Latino , Mexican",0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanic Mexican American,0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanic latina,0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanic or Latino,0,1,0,0,0,0,0,1,,,,,,,,,,
"Hispanic, Latino, Mexican",0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanic/Latino (Mexican),0,1,0,0,0,0,0,1,,,,,,,,,,
"Hispanic/Latino, Mexican-American",0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanic/Mexican,0,1,0,0,0,0,0,1,,,,,,,,,,
Hispanict,0,1,0,0,0,0,0,1,,,,,,,,,,
Hispano,0,1,0,0,0,0,0,1,,,,,,,,,,
Homo sapien,0,0,0,0,0,0,0,1,,,,,,,,,,
Human,0,0,0,0,0,0,0,1,,,,,,,,,,
Human,0,1,0,0,0,0,0,1,,,,,,,,,,
Human race,0,0,0,0,0,0,0,1,,,,,,,,,,
IDK,0,0,0,0,0,0,0,1,,,,,,,,,,
Idk,0,1,0,0,0,0,0,1,,,,,,,,,,
Idk,1,1,0,0,0,0,0,1,,,,,,,,,,
Indigenous,0,0,0,0,0,0,0,1,,,,1,,,,,,1
Indigenous,0,1,0,0,1,0,0,1,,,,1,,,,,,1
Indigenous Mexican,0,1,0,0,1,0,0,1,,,,1,,,,,,1
Iranian,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
Irish,0,0,0,0,0,0,0,1,,,,,1,,,,,1
Israeli,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
Jewish,0,0,0,0,0,0,0,1,,,,,,,,,,
LATINA,0,1,0,0,0,0,0,1,,,,,,,,,,
Latim,0,1,0,0,0,0,0,1,,,,,,,,,,
Latin,0,1,0,0,0,0,0,1,,,,,,,,,,
Latina,0,1,0,0,0,0,0,1,,,,,,,,,,
Latinamerican,0,1,0,0,0,0,0,1,,,,,,,,,,
Latino,0,1,0,0,0,0,0,1,,,,,,,,,,
Latino Mexican,0,1,0,0,0,0,0,1,,,,,,,,,,
Latino- Mexico and Honduras,0,1,0,0,0,0,0,1,,,,,,,,,,
Latino/hispanic,0,1,0,0,0,0,0,1,,,,,,,,,,
MEXICAN,0,1,0,0,0,0,0,1,,,,,,,,,,
Many races,0,0,0,0,0,0,0,1,,,,,,,,,,
Mestiza,0,1,0,0,0,0,0,1,,,,,,,,,,
Mestizo,0,1,0,0,0,0,0,1,,,,,,,,,,
Mexican,0,1,0,0,0,0,0,1,,,,,,,,,,
Mexican,0,1,0,0,0,1,0,1,,,,,,,,,,
Mexican,0,1,0,0,1,0,0,1,,,,,,,,,,
Mexican,0,1,0,1,0,0,0,1,,,,,,,,,,
Mexican / american,0,1,0,0,0,0,0,1,,,,,,,,,,
Mexican American,0,1,0,0,0,0,0,1,,,,,,,,,,
Mexican Merican,0,1,0,0,0,0,0,1,,,,,,,,,,
Mexican american,0,1,0,0,0,0,0,1,,,,,,,,,,
"Mexican, American",0,1,0,0,0,0,0,1,,,,,,,,,,
"Mexican, American, Hispanic",0,1,0,0,0,0,0,1,,,,,,,,,,
Mexico,0,1,0,0,0,0,0,1,,,,,,,,,,
Middle Eastern,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
Middle Eastern,0,1,0,1,1,1,0,1,,,,,1,,,,1,1
Middle Eastern American,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
Middle eastern,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
Mixed,0,0,0,0,0,0,0,1,,,,,,,,,,
Mixed,0,1,0,0,0,0,0,1,,,,,,,,,,
Mixed American Born,0,0,0,0,0,0,0,1,,,,,,,,,,
Mixed race,0,0,0,0,0,0,0,1,,,,,,,,,,
Mixed race spanish/native Mexican,0,1,0,0,0,0,0,1,,,,1,,,,,,
Multi Racial,0,0,0,0,0,0,0,1,,,,,,,,,,
Multi-Cultural,0,0,0,0,0,0,0,1,,,,,,,,,,
Multiracial,0,0,0,0,0,0,0,1,,,,,,,,,,
Native American,0,0,0,0,0,0,0,1,,,,1,,,,,,1
Native American,1,0,0,0,0,0,0,1,,,,1,,,,,,1
Native American from mother and father's side.,1,0,0,0,1,1,0,1,,,,1,,,,,,1
Nicaraguan,0,1,0,0,0,0,0,1,,,,,,,,,,
Nn,0,1,0,0,0,0,0,1,,,,,,,,,,
None,0,1,0,0,0,0,0,1,,,,,,,,,,
Otaku,0,0,0,0,0,0,0,1,,,,,,,,,,
Other,0,1,0,0,0,0,0,1,,,,,,,,,,
PUERTO RICAN,0,1,0,0,0,0,0,1,,,,,,,,,,
Parsi Zoroastrian,0,0,0,0,0,1,0,1,,,,,1,,,,1,
Peruvian Indigenous,0,1,0,0,1,0,0,1,,,,1,,,,,,1
Per�,0,1,0,0,0,0,0,1,,,,,,,,,,
"Polish, Czechoslovakian, Scandinavian",1,1,0,1,1,1,0,1,,,,,,,,,,1
Portuguese,0,0,0,0,1,0,0,1,,,,,,,,,,1
Puerto 3,0,1,0,0,0,0,0,1,,,,,,,,,,
Puerto Rican,0,1,0,0,0,0,0,1,,,,,,,,,,
Puerto Rican,0,1,0,0,1,0,0,1,,,,,,,,,,
Puerto Rican and Honduran,0,1,0,0,0,0,0,1,,,,,,,,,,
Puerto Rico,0,1,0,0,0,0,0,1,,,,,,,,,,
Puerto rica,0,1,0,0,0,0,0,1,,,,,,,,,,
Puerto rico,0,1,0,0,0,0,0,1,,,,,,,,,,
Puertorican,0,1,0,0,0,0,0,1,,,,,,,,,,
Puertorrique�o,0,1,0,0,0,0,0,1,,,,,,,,,,
Refuse,0,0,0,0,0,0,0,1,,,,,,,,,,
Russian,0,0,0,0,1,0,0,1,,,,,,,,,,1
Salvadoran,0,1,0,0,0,0,0,1,,,,,,,,,,
Scythian,0,0,0,0,0,0,0,1,,,,,,,,,,
South American,0,1,0,0,0,0,0,1,,,,,,,,,,
Spain,0,1,0,0,0,0,0,1,,,,,,,,,,
"Spain, Puerto Rico",0,1,0,0,0,0,0,1,,,,,,,,,,
Spaniard,0,1,0,0,0,0,0,1,,,,,,,,,,
Spaniard,0,1,0,0,0,1,1,1,,,,,,,,,,
Spanish,0,1,0,0,0,0,0,1,,,,,,,,,,
Spanish,0,1,0,1,0,0,0,1,,,,,,,,,,
Spanish Indian,0,1,0,1,0,0,0,1,,,,,,,,,,
Syrian,0,1,0,1,1,0,0,1,,,,,,,,,1,1
Taino,0,1,0,0,0,0,0,1,,,,1,,,,,,1
Tepehuanes,0,1,0,0,0,0,0,1,,,,1,,,,,,1
VENEZUELAN,0,1,0,0,0,0,0,1,,,,,,,,,,
Viking,0,0,0,0,0,0,0,1,,,,,,,,,,
West Indian,0,0,0,0,0,0,0,1,1,,,,,,,,,1
White Irish Indian Japanese hawawiien,0,0,0,0,0,1,0,1,,,,1,1,,1,,,1
White cuban,0,1,0,0,0,0,0,1,,,,,1,,,,,
White or Caucasian,0,0,0,0,0,0,0,1,,,,,1,,,,,1
White-Spaniard,0,1,0,0,0,0,0,1,,,,,1,,,,,
White/Mexican Mix,0,1,0,0,0,0,0,1,,,,,1,,,,,
armenian,0,0,0,0,1,1,0,1,,,,,,,,,,1
dont know what to consider as race,0,1,0,0,0,0,0,1,,,,,,,,,,
hispanic,0,1,0,0,0,0,0,1,,,,,,,,,,
"hispanic, mexican",0,1,0,0,0,0,0,1,,,,,,,,,,
human,0,0,0,0,0,0,0,1,,,,,,,,,,
human race,0,0,0,0,0,0,0,1,,,,,,,,,,
im hispanic,0,1,0,0,1,0,0,1,,,,,,,,,,
indigenous,0,0,0,0,0,0,0,1,,,,1,,,,,,1
jew,0,0,0,0,0,0,0,1,,,,,,,,,,
jewish,0,0,0,0,0,0,0,1,,,,,,,,,,
latin,0,1,0,0,0,0,0,1,,,,,,,,,,
latino,0,1,0,0,0,0,0,1,,,,,,,,,,
latinx,0,1,0,0,0,0,0,1,,,,,,,,,,
mestizo,0,1,0,0,1,0,0,1,,,,,,,,,,
mex/white,0,1,0,0,0,0,0,1,,,,,,,,,,
mexican,0,1,0,0,0,0,0,1,,,,,,,,,,
mexican american,0,1,0,0,0,0,0,1,,,,,,,,,,
middle Eastern,0,0,0,0,0,0,0,1,,,,,1,,,,1,1
mixed,0,1,0,0,0,0,0,1,,,,,,,,,,
mixed race Japanese/Polish,0,0,0,0,0,0,0,1,,,,,1,1,,,,1
n/a,0,1,0,0,0,0,0,1,,,,,,,,,,
not important,0,0,0,0,0,0,0,1,,,,,,,,,,
"peruvian, palestinian",0,1,0,0,1,0,0,1,,,,,,,,,1,
puertorican race,0,1,0,0,0,0,0,1,,,,,,,,,,
spanish,0,1,0,0,0,0,0,1,,,,,,,,,,
run;

/*Pull out race variables to fix O/S coding*/
Data race_fix;
	set sl_dat;
	keep caseid racegroup weight_genB_13 filter_rand
		f2a_1_t f2a_2_t f2a_3_t f2a_8_t
		f2b_1_t f2b_2_t f2b_13_t f2b_15_t
		Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR
		;
run;


/*merge on each file one by one, create flags, check recodes*/
proc sort data= race_fix; by f2a_1_t Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR; run;
proc sort data= f2a_1_t; by f2a_1_t Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR; run;
Data race_fix;
	merge race_fix f2a_1_t;
		by f2a_1_t Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR;
	rename
		Black_add=Black_working
		Hisp_add=Hisp_working
		MENA_add=MENA_working
		AmIndAN_add=AmIndAN_working
		White_add=White_working
		Asian_add=Asian_working
		NHoPI_add=NHoPI_working
		SOR_add=SOR_working
		MENA_Coded=MENA_Coded_working
		Drop_SOR=Drop_SOR_working;	
run;

proc freq data= race_fix;
	table  Black*Black_working
			Hisp*Hisp_working
			MENA*MENA_working
			AmIndAN*AmIndAN_working
			White*White_working
			Asian*Asian_working
			NHoPI*NHoPI_working
			SOR*SOR_working
			MENA_Coded_working
			Drop_SOR_working/list missing norow nocol;
	title f2a_1_t;
run;

%macro loop(varlist);
%let i=1;
%do %while (%scan(&varlist, &i, |) ^=%str());
%let var=%scan(&varlist, &i, |); 
%put &var &i;

proc sort data= race_fix; by &var Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR; run;
proc sort data= &var; by &var Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR; run;

%if &i = 1 %then %do; 
%put test;
Data race_fix;
	merge &var race_fix ;
		by &var Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR;
	
	if Black=1 or Black_add=1 or Black_working=1 then Black_working=1;
	if Hisp=1 or Hisp_add=1 or  Hisp_working=1 then  Hisp_working=1;
	if MENA=1 or MENA_add=1 or  MENA_working=1 then  MENA_working=1;
	if AmIndAN=1 or AmIndAN_add=1 or  AmIndAN_working=1 then  AmIndAN_working=1;
	if White=1 or White_add=1 or  White_working=1 then  White_working=1;
	if Asian=1 or Asian_add=1 or  Asian_working=1 then  Asian_working=1;
	if NHoPI=1 or NHoPI_add=1 or  NHoPI_working=1 then  NHoPI_working=1;
	if SOR=1 or SOR_add=1 or  SOR_working=1 then  SOR_working=1;
	if MENA_Coded=1 or MENA_Coded_add=1 or  MENA_Coded_working=1 then  MENA_Coded_working=1;
	if Drop_SOR=1 or Drop_SOR_add=1 or  Drop_SOR_working=1 then  Drop_SOR_working=1;
	
run;
	%end;

%else %if &i > 1 %then %do;  %put test2;
Data race_fix;
	merge  race_fix (drop= Black_add	Hisp_add	MENA_add	AmIndAN_add	White_add	
				Asian_add	NHoPI_add	SOR_add	MENA_Coded	Drop_SOR) &var;
		by &var Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR;
	
	if Black=1 or Black_add=1 or Black_working=1 then Black_working=1;
	if Hisp=1 or Hisp_add=1 or  Hisp_working=1 then  Hisp_working=1;
	if MENA=1 or MENA_add=1 or  MENA_working=1 then  MENA_working=1;
	if AmIndAN=1 or AmIndAN_add=1 or  AmIndAN_working=1 then  AmIndAN_working=1;
	if White=1 or White_add=1 or  White_working=1 then  White_working=1;
	if Asian=1 or Asian_add=1 or  Asian_working=1 then  Asian_working=1;
	if NHoPI=1 or NHoPI_add=1 or  NHoPI_working=1 then  NHoPI_working=1;
	if SOR=1 or SOR_add=1 or  SOR_working=1 then  SOR_working=1;
	if MENA_Coded=1 or MENA_Coded_add=1 or  MENA_Coded_working=1 then  MENA_Coded_working=1;
	if Drop_SOR=1 or Drop_SOR_add=1 or  Drop_SOR_working=1 then  Drop_SOR_working=1;
	
run;
	%end;

proc freq data= race_fix;
	table  Black*Black_add*Black_working
			Hisp*Hisp_add*Hisp_working
			MENA*MENA_add*MENA_working
			AmIndAN*AmIndAN_add*AmIndAN_working
			White*White_add*White_working
			Asian*Asian_add*Asian_working
			NHoPI*NHoPI_add*NHoPI_working
			SOR*SOR_add*SOR_working
			MENA_Coded*MENA_Coded_add*MENA_Coded_working
			Drop_SOR*Drop_SOR_add*Drop_SOR_working/list missing norow nocol;
	title &var;
run;

%let i=%eval(&i+1);
%end;
%mend;
%let temp=f2a_2_t|f2a_3_t|f2a_8_t|f2b_1_t|f2b_2_t|f2b_13_t|f2b_15_t;
%loop(&temp);

/*examine droped SOR's to qc*/
data qc2;
	set race_fix;
	if Drop_SOR_working=1;
	keep f2b_15_t f2a_8_t 	Black	Hisp	MENA	AmIndAN	White	
	Asian	NHoPI	SOR	Black_working	Hisp_working	MENA_working	
	AmIndAN_working	White_working	Asian_working	NHoPI_working	
	SOR_working	MENA_Coded_working	Drop_SOR_working;
	
run;

/*rename, keep original flags as _orig for comparison*/
Data race_fix_use;
	set race_fix;
	if  Drop_SOR_working=1 then SOR_working=0;
	rename Black=Black_orig	
		Hisp=Hisp_orig	
		MENA= MENA_orig
		AmIndAN	= AmIndAN_orig
		White= White_orig
		Asian= Asian_orig
		NHoPI= NHoPI_orig
		SOR= SOR_orig
		MENA_coded=MENA_coded_orig
		
		Black_working=Black	
		Hisp_working=Hisp
		MENA_working=MENA
		AmIndAN_working=AmIndAN
		White_working=White
		Asian_working=Asian
		NHoPI_working=NHoPI
		SOR_working=SOR
		MENA_Coded_working=MENA_coded
		;
run;

*fill zeros;
Data race_fix_use;
	set race_fix_use;
	if Black=. then Black=0;
	if Hisp=. then Hisp=0;
	if MENA=. then MENA=0;
	if AmIndAN=. then AmIndAN=0;
	if White=. then White=0;
	if Asian=. then Asian=0;
	if NHoPI=. then NHoPI=0;
	if SOR=. then SOR=0;
	if MENA_coded=. then MENA_coded=0;		
run;

*check;
proc freq data= race_fix_use;
	table  Black*Black_orig
			Hisp*Hisp_orig
			MENA*MENA_orig*MENA_Coded
			AmIndAN*AmIndAN_orig
			White*White_orig
			Asian*Asian_orig
			NHoPI*NHoPI_orig
			SOR*SOR_orig*Drop_SOR_working
			
			/list missing norow nocol;
	title "";
run;

proc freq data= sl_dat;
	weight weight_genB_13; 
	table racegroup / list missing norow nocol;
run;


proc freq data= race_fix_use;
	weight weight_genB_13; 
	table Black Black_orig
			Hisp Hisp_orig
			MENA MENA_orig MENA_Coded
			AmIndAN AmIndAN_orig
			White White_orig
			Asian Asian_orig
			NHoPI NHoPI_orig
			SOR SOR_orig / list missing norow nocol;
run;

/*save old dataset*/
data sl_dat_oldrace; set sl_dat; run;

/*drop prior race flags*/
data sl_dat;
	set sl_dat;
	drop Black	Hisp	MENA	AmIndAN	White	Asian	NHoPI	SOR;
run;

/*merge in new race flags*/
proc sort data=sl_dat; by caseid weight_genB_13; run;
proc sort data=race_fix_use; by caseid weight_genB_13; run;

data sl_dat;
	merge sl_dat race_fix_use; 
	by caseid weight_genB_13;
	drop Black_add	Hisp_add	MENA_add	AmIndAN_add
	     White_add	Asian_add	NHoPI_add	SOR_add;
run;

/*QC*/
proc freq data= sl_dat_oldrace;
	weight weight_genB_13; 
	table Black Hisp MENA 
			AmIndAN White Asian 
			NHoPI SOR  / list missing norow nocol;
	title "old flags";
run;


proc freq data= sl_dat;
	weight weight_genB_13; 
	table Black Black_orig
			Hisp Hisp_orig
			MENA MENA_orig MENA_Coded
			AmIndAN AmIndAN_orig
			White White_orig
			Asian Asian_orig
			NHoPI NHoPI_orig
			SOR SOR_orig / list missing norow nocol;
	title "new flags";
run;

/*by experimental group*/
proc means data= sl_dat mean stderr;
	weight weight_genB_13; 
	class filter_rand;
	var Black Black_orig
			Hisp Hisp_orig
			MENA MENA_orig MENA_Coded
			AmIndAN AmIndAN_orig
			White White_orig
			Asian Asian_orig
			NHoPI NHoPI_orig
			SOR SOR_orig ;
run;

proc ttest data= sl_dat;
	weight weight_genB_13; 
	class filter_rand;
	var Black Black_orig
			Hisp Hisp_orig
			MENA MENA_orig MENA_Coded
			AmIndAN AmIndAN_orig
			White White_orig
			Asian Asian_orig
			NHoPI NHoPI_orig
			SOR SOR_orig ;
run;


/*create multiracial flag*/

data sl_dat;
	set sl_dat;
		if sum(white, black, asian, AmIndAN, SOR, NHoPI)>1 then Multiracial=1;
			else Multiracial=0;
		if MENA=1 or  MENA_orig=1 or MENA_Coded=1 then MENA_comb=1;
			else MENA_comb=0;
run; 
			
proc freq data= sl_dat;
	table  Multiracial*white*black*asian*AmIndAN*SOR* NHoPI* MENA*hisp
			MENA* MENA_orig* MENA_Coded* MENA_comb/ list missing norow nocol;
run; 

 
proc freq data= sl_dat;
	weight weight_genB_13;
	table Hisp White Black
		Asian AmIndAN NHoPI MENA SOR
		Multiracial / list missing norow nocol;
run;


